| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to Columns
I have a macro which parses a comma delimited string, but have just
discovered an issue (XL2000)... The output from this macro is input for further processing BUT apparently the default behaviour for Excel is that once the Text to Columns action has been performed, to continue doing it... problem is, subsequent entries that contain comma's are being automagickally parsed, with the result that some data is then being overwritten (because it's parsed into the wrong columns). is there some way to cancel this once the intial macro has been completed? TIA S -- there are 10 types of people in this world those who understand binary, and those who don't... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Threaded Mode
