Hi,
I have string in Column B.
I need vba to find first alphabet (a-z) and insert character "^".
Please refer attachment, in b2 I have a string in C2 first alphabet is f. Hence "^" symbol is inserted before f.
Hi,
I have string in Column B.
I need vba to find first alphabet (a-z) and insert character "^".
Please refer attachment, in b2 I have a string in C2 first alphabet is f. Hence "^" symbol is inserted before f.
VBA solution:
WBD![]()
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
METHOD A
METHOD B![]()
Please Login or Register to view this content.
Assumption: Works if the last digits before the letters is a 4 digit year ... as is in all your examples![]()
Please Login or Register to view this content.
![]()
Last edited by nimrod1313; 08-10-2022 at 05:49 PM.
updated code from last post so that the "intent" is clearer
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Last edited by nimrod1313; 08-11-2022 at 10:18 AM.
SOLUTION IF YEAR ASSUMPTION IS INVALID
(i.e. traversing the string looking for the change from numbers to letters.)
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks