Converting Text

[Dig]

I just was given a file, fairly large, to use for a mailing list. The file
contains some text data in caps and other data in regular First letter cap
text.

Is there an easy way to convert all the text to First letter cap?

Thanks

 

[Freemini]

If you data is in say column A, insert a blank column at B

in B1 type the formula =PROPER(A1)

Copy this to all cells to the last row.

Then copy column B into column A using paste special, values only, and
finally delete the column B that you inserted earlier.

This will turn "smith" into Smith and "mr jones" into Mr Jones"

Related to this are the functions Lower and Upper

Hope this helps.

Mike

 

[Dig]

Worked like a charm.

Thanks so much.