Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sperate from the space, in text, in the same cell
Hi..
Is there a way tpo seperate or extract out first or last name from the same cell? for example, if in cell A1 we have John Smith, can I able top extract out just John or Smith in cell B1? Any help will be appreciated thx -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate Text from a cell by space into other cells | Excel Worksheet Functions | |||
deleting space in cell behind text | Excel Discussion (Misc queries) | |||
How do I remove a space infront of text in a cell? | Excel Discussion (Misc queries) | |||
Location of space in a text in a cell | Excel Worksheet Functions | |||
Removing unwanted space at end of text cell | Excel Programming |