View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ldiaz ldiaz is offline
external usenet poster
 
Posts: 48
Default How separate a Long text by first space?


I have texts like this in a field example
Column A
a-x00-sss-rtds Right tool, die short
a-x00-sss-maxss Max SS
a-x00-sss-longdie Long die used
a-x00-sss-red Red Solution

I want them separated by first space that exist from left to right, example:

Column A Column B
a-x00-sss-rtds Right tool, die short
a-x00-sss-maxss Max SS
a-x00-sss-longdie Long die used
a-x00-sss-red Red Solution


Thanks in advanced.



--
Lorenzo DÃ*az
Cad Technician