I'd like to have a macro to loop through Column B for the word "ABC" and return the value of the 1st number/word in the found cell.
I have attached a spreadsheet with the Before and After results.
Appreciate your help and thank you for the assistance!
wk
Try
Please Login or Register to view this content.
Hi wkhor,
See the before sheet, Green cells -
Find_Copy.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
If you are looking for a formula, in B1 enter =TRIM(IF(NOT(ISERROR(FIND("ABC",B1))), LEFT(B1,FIND(" ",B1)),OFFSET(B1,-1,-1))) and fill this down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks