If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Very useful to be able to copy & paste text in error dialogue box | Marten Tieleman | General Discussions | 2 | May 25th, 2005 12:49 AM |
unable to copy and paste color text as a (Picture enhance) | Taranjit Singh via OfficeKB.com | Powerpoint | 6 | April 5th, 2005 06:13 PM |
How do you copy and paste into an *existing* text box in Publisher | Judi | Publisher | 2 | November 18th, 2004 05:15 PM |
Copy paste from Access to Excel, numbers pasted as text | Dig314 | General Discussion | 1 | November 3rd, 2004 01:15 AM |
Text boxes-help | Jon Peltier | Charts and Charting | 0 | January 26th, 2004 05:46 PM |