how do you format Capitalization

[elisa]

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]

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.]

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]

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

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.