Hello:
Please refer to attached file.
I need VB Code to check data in column A:C to do following.
1. Chech to see if 1st char in aby cell is blank, if blank delete blank space.
2. Convert Data in column B and C so that 1st character is capital and others lower case.
Let me know if you have any questions.
Thanks.
Riz
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Try this;
Please Login or Register to view this content.
Last edited by PaulSP8; 02-14-2020 at 05:29 AM. Reason: Forgot about Column A :-|
Hello:
Thanks a lot to both of you.
Works
Riz
I have been playing with Pauls code.
Try:
Please Login or Register to view this content.
Another way (at its heart, a combo of PaulSP8 and mehmetchik's methods, sort of)...
Please Login or Register to view this content.
Last edited by Rick Rothstein; 02-14-2020 at 10:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks