capitalize

[#1]

Hi,

Any suggestions how you can present your data in a list box with the first position of the string as an upper-case and the rest of the string as lower case?

For example: in data: john, john-T ,

                    in list box: John, John-t

/Anders

[rohit214]

hey buddy

use

=capitalize('john, john-T')

thanks

rohit

[its_anandrjs]

Hi,

See the attached sample file.

Rgds

Anand

[SunilChauhan · Accepted solution]

try this

=Upper(left(Fieldname,1)) &lower(mid(Fieldname,2,len(Fieldname)-1))

[#5]

Works

Thanks

[rohit214]

hi,

use the expression shown in below.you will get exatly what you want in your answer

=Upper(left(FieldName,1))& lower(mid(FieldName,2,4)) &Upper(left(FieldName,1)) & lower(mid(FieldName,2,4)) &'-'& lower(right(FieldName,1))

thanks

rohit

[its_anandrjs]

Hi,

Without the use of Upper only use with Capitalize

Capitalize(ColA)

If data is correct ise capitalize it will faster also.

See attached file.

Rgds

Anand

[#8]

Hi,

Thanks, but capitalize will transform john-T to John-T. The T will still be an upper case.

/Anders

[its_anandrjs]

Hi,

Now see the attached

by using

By this 

=Capitalize( Left ( ColA,len(ColA)-1))&lower(Right(ColA,1))

you get the desire out put that you want John, John-t

Rgds

Annad

[its_anandrjs]

Hi,

Can you check your result now it is correct or not.

Rgds

Anand