Extract exact part of the text in Excel

Question

I have a column with the following type of text in it:

256 items delivered by supplier (LLC Printlogic)<br>
436 items delivered by supplier (LLC Mango)<br>
500 items shipped to supplier (Arteco Inc)<br>

How to extract value in the brackets? The result should be the following:

LLC Printlogic<br>
LLC Mango<br>
Arteco Inc

user4039065 · Accepted Answer · 2016-03-03 09:18:52Z

2

There are a number of ways to parse text. Here is one of them.

=REPLACE(REPLACE(A2, FIND(")", A2), LEN(A2), ""),1, FIND("(", A2), "")

answered Mar 3, 2016 at 9:18

user4039065

Sign up to request clarification or add additional context in comments.

Comments

Rosetta · Accepted Answer · 2016-03-03 09:49:50Z

0

one alternative,

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)&"<br>"

answered Mar 3, 2016 at 9:49

Rosetta

2,7351 gold badge17 silver badges30 bronze badges

Ron Rosenfeld · Accepted Answer · 2016-03-03 13:33:24Z

0

And another, that assumes the characters at the end are enclosed in <...> but not might always be <br>

=SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),")","")

Note that that same formula will also work on your original post, before it was edited and the <br> added at the end of each line:

answered Mar 3, 2016 at 13:19

Ron Rosenfeld

62.1k7 gold badges35 silver badges72 bronze badges