I would do it with 2 formulas...

=LEFT(E1, FIND(" ", E1)-1)
and
=MID(E1, FIND(" ", E1)+1, 256)

That will give you the seperate values. You can then copy and paste them as
values if you wish...
--
HTH...

Jim Thomlinson


"ldiaz" wrote:


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