LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I'd like to have the X-axis a fixed length. Ake Charts and Charting in Excel 0 September 25th 08 05:42 PM
Fixed Length, Text Formatted Novice2000 Excel Discussion (Misc queries) 2 May 13th 08 06:06 PM
fixed length file Steve S[_2_] Excel Discussion (Misc queries) 2 March 13th 07 04:12 PM
Fixed length text file Eric Excel Discussion (Misc queries) 1 July 12th 06 10:02 PM
Search a Column by text length kb_63 Excel Worksheet Functions 2 May 6th 05 09:17 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"