Copy Column A to Column B so you have the same original list in both
columns. Select Column A and click Edit/Replace on Excel's menu bar. Put the
following in the "Find what" field...

" *"

but leave out the quote marks so only a space followed by an asterisk appear
in the field... and leave the "Replace with" field empty... then click the
"Replace All" button. Now select Column B and put the following in the "Find
what" field (still leave the "Replace with" field empty)...

"*-* "

again, leave out the quote marks so only asterisk, dash, asterisk space
appear in the field... then click the "Replace All" button. Your text should
be distributed in your columns as you wanted.

--
Rick (MVP - Excel)


"ldiaz" wrote in message
...

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