sorry just a correction for Capitalization question

elisa · Apr 30th, 2002, 08:49 AM

A correction for the capitalization problem I had earlier. I want "field Trip Ex" in that format. So first word not capitalized all the other one are.
Thank you again.

Mark W. · Apr 30th, 2002, 08:54 AM

If A1 contains "field trip ex"...

=CHAR(CODE(LEFT(PROPER(A1)))+32)&RIGHT(PROPER(A1),LEN(A1)-1)

...will produce "field Trip Ex".

mdfh · Apr 30th, 2002, 09:04 AM

Or :-

=REPLACE(PROPER(A1),1,1,CHAR(CODE(LEFT(PROPER(A1),1))+32))

[ This Message was edited by: mdfh on 2002-04-30 08:27 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 08:49 AM	#1
elisa New Member Join Date: Apr 2002 Posts: 7	A correction for the capitalization problem I had earlier. I want "field Trip Ex" in that format. So first word not capitalized all the other one are. Thank you again.

Apr 30th, 2002, 08:54 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If A1 contains "field trip ex"... =CHAR(CODE(LEFT(PROPER(A1)))+32)&RIGHT(PROPER(A1),LEN(A1)-1) ...will produce "field Trip Ex".

Apr 30th, 2002, 09:04 AM	#3
mdfh Join Date: Apr 2002 Posts: 15	Or :- =REPLACE(PROPER(A1),1,1,CHAR(CODE(LEFT(PROPER(A1),1))+32)) [ This Message was edited by: mdfh on 2002-04-30 08:27 ]