Separate a string of text from a cell

**albardit18** · 06-03-2011, 03:59 PM

Hey guys,

I am using excel 2010 and needed some help extracting a string of text from a bunch of cells. I already know how to use the mid function but the thing about the text is that it is not the same amount of characters.

Basically this is what i have:

AWholeBunchofText/Extract
SomeMoreText/EvenMore

The one thing in common the cells have is that the text that I need to extract starts right after the slash. From that scenario I need to pull out "Extract" in the first cell and "EvenMore" for the second.

Any ideas?

**jeffreybrown** · 06-03-2011, 04:09 PM

Try this...

=MID(A1,FIND("/",A1)+1,LEN(A1))

**NBVC** · 06-03-2011, 04:17 PM

You can also just select the column and go to Data|Text to columns, select Delimited and click Next, select Other and input a / in the box. Click Finish. That should separate the strings into adjacent columns.. no formulas and no macros...

**jeffreybrown** · 06-03-2011, 04:19 PM

Yes how true, why do I overlook the obvious

**albardit18** · 06-03-2011, 04:19 PM

Awesome, Thanks a lot that did wonders :D

**albardit18** · 06-03-2011, 04:21 PM

I didn't think of that either lol but I do need it to be part of a formula for a template so minimal manual work has to be done so the formula is perfect thanks