Hello Everyone,
i really need help with the following..
A vba code that extracts a specific text along with the next 8 digit number that follows.
Only three scenarios are available:
Scenario 1: PSI2164610ETHE70162015ed366749hhe
In the first scenario I need excel to only select the string “ETHE” and the 8 digit number that follows which is 70162015 and display in the next column as ETHE70162015. Therefore, a specific text and the 8 digit column that follows is selected and displayed.
Scenario 2: PSI2164610BED70162015ed366749hhe
In the second scenario I need excel to only select the string “BED” and the 8 digit number that follows which is 70162015 and display in the next column as BED70162015. Therefore, a specific text and the 8 digit column that follows is selected and displayed.
Scenario 3: PSI2164610HRA70162015ed366749hhe
In the third scenario I need excel to only select the string “HRA” and the 8 digit number that follows which is 70162015 and display in the next column as HRA70162015. Therefore, a specific text and the 8 digit column that follows is selected and displayed.
THANK YOU SO MUCH FOR THE HELP!
Bookmarks