text to columns with inconsistent data alignment
 

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

text to columns with inconsistent data alignment
 

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