Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Strip out text copy and paste?
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200512/1 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Strip out text copy and paste?
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) In article <587a46a3fb6a8@uwe, "Mark Y via OfficeKB.com" <u12713@uwe wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Strip out text copy and paste?
WOW!!
Thats exactly what I needed and such a speedy reply! As per usual this forum comes up number 1 again, Thanks again!! Mark :-) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200512/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy and paste an Illustratorsketch with text into Excel | Excel Discussion (Misc queries) | |||
How can I copy and paste the text of a formula? | Excel Worksheet Functions | |||
Copy and paste text and dates | Excel Discussion (Misc queries) | |||
Copy and Paste to a Text Box | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |