Try Delimited text to columns with 'Space' delimiter that should solve your
problem.

If this post help resolve the issue, click 'Yes' to close the thread.

"Sarah" wrote:

I have an imported column of cells with inconsistently aligned data that I
need to split between number & company. I can do the find & replace & then
trim to get the co, but then I lose the vendor #. Is there a formula to
accomplish this?

123-45ABC Corp
1111 XYZ Co
454455 DEFasdjkfalskdfjkajsdf
1some com name