Capitalisation

F

frosty

Can anyone hel

We have a worksheet with text in that we are going to port to a data base. Before the port we wish to correct the capitalisation - as various people have input in a number of ways

Is there any way from within excel I can correct the capitisation on a whole worksheet in one go??
 
J

Jan Karel Pieterse

D

David McRitchie

See Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

Usually you would have different kinds of capitalizations in different
columns i.e. Proper or Title case; upper case; lowercase; sentence case
they all work by selection. If you really want to do the entire sheet in
one type then select all cells (Ctrl+A) and then run the macro of your
choice. I these are people's names, and addresses you would
want to make the proper case:
http://www.mvps.org/dmcritchie/excel/proper.htm#proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

frosty said:
Can anyone help

We have a worksheet with text in that we are going to port to a data base. Before the port we wish to correct the
Click to expand...
capitalisation - as various people have input in a number of ways.
 
Top