Title Case in Excel

[Annie]

Hi

I have columns of data that are all upper case or lower case that were
imported like this from another program. I know there is an UPPER and LOWER
function in Excel but is there something that I can use to format the data
into Title Case so that I can use it in a mail merge situation - names,
addresses etc.. It is too time consuming for me to manually change the
information - it's just too vast!!

Many thanks

 

[Max]

Try PROPER
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik

 

[Gary''s Student]

With data in column A, in B1 enter:

=Proper(A1) and copy down.

To replace the data in place, select the cells and run:

Sub properize()
For Each r In Selection
r.Value = Application.WorksheetFunction.Proper(r.Value)
Next
End Sub

 

[BT]

Hi Annie

Further to the previous responses, much easier for you to Copy the content
of the helper cells and use Edit / Paste Special / Values in the original
column, then delete the helper column.