View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BillyRogers BillyRogers is offline
external usenet poster
 
Posts: 78
Default 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