Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
=Upper(left(Fieldname,1)) &lower(mid(Fieldname,2,len(Fieldname)-1))
hey buddy
use
=capitalize('john, john-T')
thanks
rohit
Hi,
See the attached sample file.
Rgds
Anand
try this
=Upper(left(Fieldname,1)) &lower(mid(Fieldname,2,len(Fieldname)-1))
Works
Thanks
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
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
Hi,
Thanks, but capitalize will transform john-T to John-T. The T will still be an upper case.
/Anders
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
Hi,
Can you check your result now it is correct or not.
Rgds
Anand