Changing Existing Text Format

  • Thread starter Thread starter kevdec
  • Start date Start date
K

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
 
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)
 
Back
Top