Strip out text copy and paste?

  • Thread starter Thread starter Mark Y via OfficeKB.com
  • Start date Start date
M

Mark Y via OfficeKB.com

Hello all,

I have some text in cells A2 - A646 as below

Smith, John (LD)
Gummerson, Liz (SDLP)

The lengths of names are variable but first name is always seperated by a
comma and second name is followed by a space.

What I need to do, if possible, is to copy the first name into cell H2 and
second name into cell I2

Is there any straightforward way of doing this?

Many thanks in advance

Mark
www.familyfund.org.uk
 
One way:

If the first name is always followed by a left paren, as well:

H2: =TRIM(MID(LEFT(A2,FIND("(",A2)-1),FIND(",",A2)+1,255))
I2: =LEFT(A2,FIND(",",A2)-1)
 
WOW!!

Thats exactly what I needed and such a speedy reply! As per usual this forum
comes up number 1 again,

Thanks again!!

Mark :-)
 
Back
Top