Splitting data from one column into multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data imported from an OCR scan that has misread a portion of a table and put 3 columns worth of data into one column, any way to split these based on horizontal alignment, delimitation etc?

Thanks
 
Hi!

Probably!!

It depends on how ordered your mixed-up data is. Could you post
representative sample? Potential delimiters like spaces, commas o
whatever will be important.
Meanwhile, have a look at Data > Text to columns. This is often the wa
to get there.

Al
 
My suggestion would be to try Data>TextToColumns first, then supplement with
text/data functions (Left, Right, Mid) as needed.
Also, Inserting/Deleting groups of empty cells (using ShiftCellsRight &
ShiftCellsLeft) is often a very convient way to get unruly data to "line up"
into columns without copying & pasting.

--
George Nicholson

Remove 'Junk' from return address.


Th0r0n said:
I have data imported from an OCR scan that has misread a portion of a
Click to expand...
table and put 3 columns worth of data into one column, any way to split
these based on horizontal alignment, delimitation etc?
 
You must log in or register to reply here.

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
splitting data from one column into two 2
split one column into multiple columns 2
Splitting Data from One Worksheet to Many Automatically 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Split column contents (de-concantenate) 7
Splitting cells in Excel 2007 1
Split cells across multiple columns 1

Back
Top