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
--
Kind regards

Ann Shaw

Try PROPER
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"Annie" wrote:
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
--
Kind regards

Ann Shaw

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
--
Gary''s Student - gsnu200800


"Annie" wrote:

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
--
Kind regards

Ann Shaw

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.

"Annie" wrote:

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
--
Kind regards

Ann Shaw