Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting capitals to non-capitals

Status
Not open for further replies.

Dee0612

Technical User
May 2, 2005
17
0
0
GB
Hi,

Please can I have help in converting data taken from attachmate from capital letters into small letters. I have this that Calculus kindly provided a while ago which does it except for the first letter but not sure how to make the first letter small also!

For X = 2 To Len(freq)
If Mid(freq, X - 1, 1) <> " " Then freq = Left(freq, X - 1) & LCase(Mid(freq, X, 1)) & Mid(freq, X + 1, Len(freq))
Next X

thanks
 
sorry, found out the answer. Variable = LCase(Variable).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top