Hello,
I am looking for a VBA that looks at the value of a cell and capatilizes all letters upto the first number.
So for example, a cell containing "cOuldBE463.now" would become "COULDBE463.now".
I have attached an example sheet with 4 different examples.
Thanking you in advance.
Using Power Query, load your file to PQ. Split the column based upon the delimeter "Non Digit to Digit." Upper Case the split column. Merge the columns back together. Here is the Mcode for that action
File attached for your review.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Try the below code
Please Login or Register to view this content.
How aboutPlease Login or Register to view this content.
alansidman: Thank you for your help, couldn't really follow what this code was doing other than it put the data into a table which is something I don't want to do. Thank you for your time and help.
Other two suggestions I understand a little more, have tried them and both work so thank you.
You're welcome & thanks for the feedback.
Suggest you clcik on the link in my signature about Power Query
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks