How to extract a specific string of data from a cell

f4ichick02
f4ichick02 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
==MID(B1,FIND("REV",B1),FIND(" ",B1,FIND("REV",B1)+5)-FIND("REV",B1))

Author

Commented:
Perfect, Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial