Splitting data from one column into multiple columns

T

Th0r0n

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
 
A

AlfD

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
 
G

George Nicholson

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?
 
Top