Capitals to Lower case but keeping First letters of each name as a capitals

[Joneye]

WOW,

As above really, Capitals to Lower case but keeping First letters of each name as a capitals...

i.e.

JON SMITH but change to Jon Smith

But there may well be names that have more letters etc...

 

[MrVillareal]

Hi Friend

Try this one:

Excel Workbook
	A	B
1	JON SMITH	Jon Smith
Sheet9

Excel 2010

Cell Formulas
Range	Formula
B1	=PROPER(A1)

 

[Trevor G]

Try using Proper as formula

Excel Workbook
	I	J
1	JOHN SMITH	John Smith
Sheet5

 

[villy]

Use PROPER Function..

 

[machopicho]

Search PROPER Function

 

[Joneye]

Guess what???

IM ALL OVER THE = PROPER formula...LOL

Thanks so much guys...