Separate a string of text from a cell

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?

Try this...

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

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...

Yes how true, why do I overlook the obvious

Originally Posted by jeffreybrown

Yes how true, why do I overlook the obvious

If it wasn't you today, it would be me tomorrow

It's easy to forget... I too go overcomplicated sometimes, oblivious to the obvious....

edit: Well, there you go... the formula was the way to go here....

Glad to hear it gets you on your way...