I think he has a database and needs to "proper" the names within it and hence is looking for a proper() or strtran() type solution :)


>Yeah
>
>I was thinking that myself - if it's going to be hard-coded, why bother - but I assume the "pvt" could be any TLA (three-letter acronym < g >), e.g.
>
>

>lcString = "Global Traders (" + Proper( lcCoAbbrev) + ") Ltd."
>

>
>>Well in that case I prefer;
>>
>>

>>lcString = "Global Traders (Pvt) Ltd."
>>

>>
>><g>
>>
>>
>>
>>>Tariq
>>>
>>>Try:
>>>

>>>lcString = "Global Traders (" + Proper( Pvt) + ") Ltd."
>>>

>>>
>>>Terry
>>>>Dear Sir,
>>>>
>>>>I have a string as
>>>>
>>>>Global Traders (pvt) Ltd.
>>>>
>>>>I want to replace it with
>>>>
>>>>Global Traders (Pvt) Ltd. && word Pvt must in proper case
>>>>
>>>>When I apply proper(), it does not work due to brackets.
>>>>
>>>>
>>>>Please help