Capitalisation

[Guest]

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??

 

[Jan Karel Pieterse]

Hi Frosty,

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

Go here:

http://go.CompuServe.com/MSOfficeForum?Loc=US

(Free access if you enter a valid e-mail address)

and look for a file in the library called chngca.exe
Direct download link:

http://forums.compuserve.com/scripts/flisapi.dll/CHNGCA.XLA?ViewFile&SRV=MSOfficeForum&FID=1504&FV
F=1/.XLA

(all on a single line)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[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

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

capitalisation - as various people have input in a number of ways.