Changing Existing Text Format

[kevdec]

Help,

I know I have done this before, but cannot remember the process. I hav
a full excel spread sheet with text.

The text is mixed in ALL CAPS, all lowercase, And Up And Down Style.

Does anyone know the formula to copy and change the text to all the U
And Down Format?

Thanks in Advance!

KA

 

[Bob Phillips]

KAD,

Up And Down Style<G>?

VBA is the onlyu way I know to convert to Proper case. This code does that

Dim cell As Range

For Each cell In ActiveSheet.UsedRange
cell.Value = WorksheetFunction.Proper(cell.Value)
Next cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
=PROPER(A1)
may what you're looking for

Frank