| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 110791 | 2010-07-01 23:52:00 | Excel List Help | rob_on_guitar (4196) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1115230 | 2010-07-02 01:55:00 | Just for future reference Rob, Excel is equipped to do this with the Text To Columns function under the Data menu; it will parse (break down into constituent pieces) anything based on whatever delimiter you tell it (space, comma, pipe etc). Very handy tool!! Must try that. Sometimes the paste doesn't organise itself.... |
pctek (84) | ||
| 1115231 | 2010-07-02 02:24:00 | Must try that. Sometimes the paste doesn't organise itself.... Yeah, it's very handy if you do a lot of import work in Excel. You can also concatenate text strings together, which is the opposite of text to columns, but just as handy!! |
nofam (9009) | ||
| 1115232 | 2010-07-04 08:45:00 | Just for future reference Rob, Excel is equipped to do this with the Text To Columns function under the Data menu; it will parse (break down into constituent pieces) anything based on whatever delimiter you tell it (space, comma, pipe etc). Very handy tool!! Thanks nofam, this also works even better! Awesome stuff.:punk |
rob_on_guitar (4196) | ||
| 1 2 | |||||