Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to Column with fixed width in VBA
I have text file with about 300 lines items that are not delimited
but the width of each columns is fixed and do have the value. For example, cell 1 is char(1-2), cell 2 is char(2-14).... I want to be able to copy the whole thing in Excel, run a macro that split the string into the different cell. I can manually do it using the Text to Column function and setting the width one by one but it's time consuming since this import is occuring everyday. Can you help? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to Column with fixed width in VBA
Record a macro when you do it once and you'll see the code you want to use.
wrote: I have text file with about 300 lines items that are not delimited but the width of each columns is fixed and do have the value. For example, cell 1 is char(1-2), cell 2 is char(2-14).... I want to be able to copy the whole thing in Excel, run a macro that split the string into the different cell. I can manually do it using the Text to Column function and setting the width one by one but it's time consuming since this import is occuring everyday. Can you help? Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column fixed width | Excel Discussion (Misc queries) | |||
Text to column, fixed width | Charts and Charting in Excel | |||
Text to column, fixed width | Excel Discussion (Misc queries) | |||
Changing fixed width (column break) defaults when importing text | Excel Discussion (Misc queries) | |||
fixed column width with text string | Excel Discussion (Misc queries) |