Jan 5, 2004 #1 sborny Technical User Jun 29, 2001 157 GB Hi All, Is there a way to change any captial letters in a string to lower case. Thanks. S. Everything has an answer, it's just knowing the right question to ask. !!!!
Hi All, Is there a way to change any captial letters in a string to lower case. Thanks. S. Everything has an answer, it's just knowing the right question to ask. !!!!
Jan 5, 2004 #3 sciophyte Programmer Dec 8, 2003 66 CA and just for reference, UCase("TeSt" for uppercase conversion Upvote 0 Downvote
Jan 5, 2004 2 #4 strongm MIS May 24, 2001 20,211 GB There's a third one for 'proper' case conversion (uppercases first letter of word, lowercases remainder), but it's only available if you use StrConv: StrConv("yourString", vbProperCase) Upvote 0 Downvote
There's a third one for 'proper' case conversion (uppercases first letter of word, lowercases remainder), but it's only available if you use StrConv: StrConv("yourString", vbProperCase)
Jan 5, 2004 #5 ZOR Technical User Jan 30, 2002 2,963 GB Thankyou strongm, that will do nicely. Have a star. Just when I needed it. Regards Upvote 0 Downvote