Avatar of f4ichick02
f4ichick02
Flag for United States of America 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?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
f4ichick02

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
f4ichick02

ASKER
Perfect, Thank you
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23