| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split cell at first space
I have a list of definitions that each occupy one cell. Is there an easy way to separate the word from the definition so that they are in adjacent cells. Here's an example décalage (nm) gap; discrepancy; se sentir en décalage (par rapport aux autres) to feel out of step I just need the cells split at the first space. When I tried text to columns it started a new cell at each space in the original cell. -- Billy Rogers Dallas,TX Currently Using Office 2000 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
split cell at first space
If your text is is A1, use these formulas in A2 and A3:
A2: =LEFT(A1,FIND(" ",A1)-1) A3: =RIGHT(A1,LEN(A1)-FIND(" ",A1)) hth Andrew Taylor BillyRogers wrote: I have a list of definitions that each occupy one cell. Is there an easy way to separate the word from the definition so that they are in adjacent cells. Here's an example décalage (nm) gap; discrepancy; se sentir en décalage (par rapport aux autres) to feel out of step I just need the cells split at the first space. When I tried text to columns it started a new cell at each space in the original cell. -- Billy Rogers Dallas,TX Currently Using Office 2000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split text at space | Excel Discussion (Misc queries) | |||
| Split column on first space | Excel Discussion (Misc queries) | |||
| Text to columns, split at first space only | New Users to Excel | |||
| Split field based on number of characters and space | Excel Worksheet Functions | |||
| Split field based on number of characters and space | Excel Programming | |||
Linear Mode
