View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Luci Luci is offline
external usenet poster
 
Posts: 11
Default 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