Helppppp Text extraction formula

**Deandre305** · 11-19-2015, 04:05 PM

Hey guys,

Any one know how the heck to I extract "Allen Burk" from this text string "Allen Burk, USA".
Would really appreciate guys.

**ConneXionLost** · 11-19-2015, 04:11 PM

How about:

Please Login or Register  to view this content.

Cheers,

**Deandre305** · 11-19-2015, 04:16 PM

Thanks I'll give it a try and let you know what happened

**Deandre305** · 11-19-2015, 04:21 PM

It worked like a charm. You Genius. lol

**Deandre305** · 02-03-2016, 04:01 PM

need help formula for separating Pal from (@ Pal)

**ChemistB** · 02-03-2016, 05:19 PM

Tough with one example. Is there always a close parentheses at the end?
Maybe
=TRIM(MID(A1, FIND("@",A1)+1, LEN(A1)-FIND("@",A1)-1))

**Deandre305** · 02-03-2016, 05:22 PM

Originally Posted by ChemistB

Tough with one example. Is there always a close parentheses at the end?
Maybe
=TRIM(MID(A1, FIND("@",A1)+1, LEN(A1)-FIND("@",A1)-1))

No parentheses just @ pal

**JohnTopley** · 02-03-2016, 05:24 PM

Removed by JT

**ChemistB** · 02-03-2016, 05:25 PM

Then assuming Pal is always at the end

=TRIM(MID(A1, FIND("@",A1)+1, 100))

Re: Helppppp Text extraction formula