We help IT Professionals succeed at work.
Get Started

How to extract a specific string of data from a cell

47 Views
Last Modified: 2015-08-03
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
Engineer
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE