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

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