software

I have entered an extensive amount of data, only to have management tell me
they want it all in upper case. Is there a way to do that without starting
over?

Assume your data is in column A. In an empty column near your data enter the
formula

=upper(A1)

and copy it down as needed. After copying the formula to the necessary
cells, select all the formulas, copy them, select the original data, and use
Edit-gt;Paste Special-gt;Values to replace the original data with the upper case.
AFter confirming that the result is what you want, delete the column with
the formulasquot;The Ozquot; wrote:

gt; I have entered an extensive amount of data, only to have management tell me
gt; they want it all in upper case. Is there a way to do that without starting
gt; over?