You can manually select the division point between columns if you use fixed
width. Of curse, this will only work if all the data is the same width.

--
Ian
--
"Luci" wrote in message
...
Hi,

I have scanned data from an unknown source at this stage that I need to
convert to excel. I can get the data ok but it is all over the place.
Text
to columns does not
work accurately either or using fixed width or delimiters with a space or
anything else. What will work given the data I have is if I can set the
length of the columns for the text, ie column 1, 12 characters, column 2,
25
characters, etc, etc. Is there a free download available for this
function
or does it potentially exist somewhere? If it was a one off I wouldnt
bother
but we are receving many sheets like this.

Thanks so much, Luci