Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I'd like to have the X-axis a fixed length. | Charts and Charting in Excel | |||
Fixed Length, Text Formatted | Excel Discussion (Misc queries) | |||
fixed length file | Excel Discussion (Misc queries) | |||
Fixed length text file | Excel Discussion (Misc queries) | |||
Search a Column by text length | Excel Worksheet Functions |