Converting Text

  • Thread starter Thread starter Dig
  • Start date Start date
D

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