changing all CAPS in a worksheet

[leda]

Hi!
Is there a way to change an entire worksheet that has all CAPS, into the "Proper" text format, without doing each cell individually?
thanks,
Leda

 

[shelron]

Yup,

function "proper"

just add a column for each column that has data, add the function, then copy the formula down the whole sheet, then you will have the new data in proper case,

one important thing though, after you have completed the above, copy and paste special-- "values" (otherwise when you delete the "old or orginal data" you will be left with #ref errors.

(essentially you convert the data to proper case, then paste the values and eliminate the formulas that got you there)

Ron

 

[Hasit]

The only way I can think of doing this is in another sheet, say SHEET2, type the following command:

=PROPER(SHEET1!A1)

Then drag that cell down and across to as many cells as necessary, which will change TEXT to Text.

There are other options such as LOWER too, which you may want to use instead.

 

[SkipVought]

Hi,

Here's the VBA apprch...

For Each c In ActiveSheet.UsedRange
   c.Value = UCase(c.Value)
Next

Hope this helps Skip,