Use Find and Mid | Message 13 of 33 | TechRepublic

Discussion on:

Using Excel's Find and Mid to extract a substring when you don't know the start point

View entire thread

Message 13 of 33

Next » « Prev

3 Votes

+ -

Use Find and Mid

Try this

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Posted by linglc@...

24th Feb 2008