f4ichick02
asked on
How to extract a specific string of data from a cell
I have an Excel file with 2 columns. Column A has the PART NUMBER and Column B has the DESCRIPTION. I am looking for information that is in Column B only. Here is an example of the data in Column B:
ALLISON 0068BS42 REV.2A PIB SIB
ALLISON 58-8119 REV 004 CONFIG 1
ALLISON 58-8119-2 REV004 CONFIG2
ALLISON 58-8124 REV 1 C445 CBCT
ALLISON 58-8180 REV 002 C445 BCM
ALLISON 58-8180-2 REV 002 C445
ALLISON 58-8184 REV 005 C445
ALLISON 58-8185 REV 004 C445
The data that I need to extract to a different cell is the REV 004, REV.2A, REV 1. Basically I need the REV + the REV number outputted to let's say column C. Is this possible?
ALLISON 0068BS42 REV.2A PIB SIB
ALLISON 58-8119 REV 004 CONFIG 1
ALLISON 58-8119-2 REV004 CONFIG2
ALLISON 58-8124 REV 1 C445 CBCT
ALLISON 58-8180 REV 002 C445 BCM
ALLISON 58-8180-2 REV 002 C445
ALLISON 58-8184 REV 005 C445
ALLISON 58-8185 REV 004 C445
The data that I need to extract to a different cell is the REV 004, REV.2A, REV 1. Basically I need the REV + the REV number outputted to let's say column C. Is this possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER