Text to column fixed length
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
|