text to columns with inconsistent data alignment

  • Thread starter Thread starter Sarah
  • Start date Start date
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
 
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

Text to columns 2
Finding keywords in several text columns 7
Copy a Table to another place with Column Alignment Displaced 1
Inconsistant character spaces extraction formula 3
Summary data 2
#VALUE 11
Text parsing - Extracting data from inconsistent data entry format. 2
text lines to rows & columns 1

Back
Top