text to columns with inconsistent data alignment

S

Sarah

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
 
P

Pankaj

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding keywords in several text columns 7
Text to columns 2
Getting Text data using the Data - Subtotal feature 1
text lines to rows & columns 1
Copy a Table to another place with Column Alignment Displaced 1
Array problem, I think.. 3
Finding, grouping, then copy/paste to new sheet 15
Text parsing - Extracting data from inconsistent data entry format. 2

Top