how do you format Capitalization

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

Another question in 3 mins, sorry. I know that we have UPPER, LOWER, PROPER function to format capitalization, but how can you format something like "field Trip Ex" or anything in that form.
Thank you

[ This Message was edited by: elisa on 2002-04-30 07:45 ]

Aladin Akyurek · Apr 30th, 2002, 08:44 AM

Quote:

On 2002-04-30 07:42, elisa wrote:
Another question in 3 mins, sorry. I know that we have UPPER, LOWER, PROPER function to format capitalization, but how can you format something like "fieldTripEx" or "field Trip Ex" or anything in that form.
Thank you

What do you want the result to be with:

"fieldTripEx"

"field Trip Ex"

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

Capitalization isn't accomplished through formatting. A capital letter is an entirely different value for its lower case counterpart. Formatting governs the way a value is displayed, but doesn't alter the underlying value.

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

Quote:

On 2002-04-30 07:44, Aladin Akyurek wrote:

Quote:

On 2002-04-30 07:42, elisa wrote:
Another question in 3 mins, sorry. I know that we have UPPER, LOWER, PROPER function to format capitalization, but how can you format something like "fieldTripEx" or "field Trip Ex" or anything in that form.
Thank you

What do you want the result to be with:

"fieldTripEx"

"field Trip Ex"

I would like the result in "field Trip Ex"
thank you.

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

Apr 30th, 2002, 08:42 AM	#1
elisa New Member Join Date: Apr 2002 Posts: 7	Another question in 3 mins, sorry. I know that we have UPPER, LOWER, PROPER function to format capitalization, but how can you format something like "field Trip Ex" or anything in that form. Thank you [ This Message was edited by: elisa on 2002-04-30 07:45 ]

Apr 30th, 2002, 08:50 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Capitalization isn't accomplished through formatting. A capital letter is an entirely different value for its lower case counterpart. Formatting governs the way a value is displayed, but doesn't alter the underlying value.