Hello,
I have a tracker with several worksheets. Each Worksheet has the following macro assigned;
The tracker also runs the following macro against all worksheets when I save it;
Please Login or Register to view this content.
Column I has entries in the format of 'uuuuuu.llllll.llllll', where the length of each section can differ and each character could be either a letter or number. I want to make all the "u" uppercase and all the 'l' lower case.Please Login or Register to view this content.
something like this
I missed the part about variable length. try this instead.Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by JLGWhiz; 02-07-2018 at 12:15 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks