Converting ALL CAPS to name formati

[Lubinski]

How can you convert a simple Excel spreadsheet listing people, addresses and telephone numbers originally types in ALL CAPS? It would be more useful and attractive to have it follow standard name format Firstname Lastname. Thanks

Rick Lubinski
Silver Lake, Ohio
9/18/02 @ 18:16

rick@think-energy.net

 

[ChrisUK]

Try using the worksheet function 'proper'

=proper("MY NAME") gives My Name as a result

 

[Lubinski]

THANKS for the assistance! This should save a lot of time.

Rick L
Silver Lake, Ohio

 

[Paul B]

Or with a marco try
Sub Proper_Case()
Application.ScreenUpdating = False
Application.EnableEvents = False
Dim cl As Range
'for whole sheet use this, will be slow if a lot is on the sheet
For Each cl In ActiveSheet.[A1].SpecialCells(xlCellTypeConstants, 2)

'for a range use something like one below
'For Each cl In ActiveSheet.[A1:B50,D1:D50,F4].SpecialCells(xlCellTypeConstants, 2)
'For Each cl In ActiveSheet.[A4,B4,C4].SpecialCells(xlCellTypeConstants, 2)

cl = Application.Proper(cl)
Next cl
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub

 

[Lubinski]

THANKS for the assistance

Rick L
Silver Lake, Ohio

 

[Jack in the UK]

Just to add to this old feed, I would not suggest using PROPER on postcodes, kinda dongt like it!