Hello,
Plese take a look at the attached screen shot.
I need to extract the two numerical values from the cell value and place them in the next two cell as shown.
I know how to do this with a formula, but I need it through a VBA script.
Could you please advise?
Thanks
Post a sample workbook together with the formulae you are currently using.
From there, coding VBA is simple, just no need to start from scratch.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This VBA code should work on Windows:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
Thank you WBD!
WBD,
Actually, there is a little "twist" to it:
There are instances when the string in the cell contains numerical values before the "/" sign like:
PL-01 / Plywood / 4 mm / 46" x 118"
The “/“ sign might occur multiple times.
I need to revise the script to only parse what is after the last "/" sign.
Could you please advise?
Thans
Last edited by plans; 06-29-2022 at 01:33 PM.
Try like this then:
WBDPlease Login or Register to view this content.
Yes!, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks