| 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 |
| 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 | |||
Threaded Mode
