| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Disecting Contents
DataText to ColumnsDelimited byCommaNextDestination.
Type in L1 or click on the refedit button and point to L1 then Finish Gord Dibben MS Excel MVP On Tue, 29 Apr 2008 09:54:00 -0700, Sandy wrote: Hi I am downloading a file and in column c the contents wil be numeric separated by commas (as many as 5 numbers separated by commas 12345678,23456789,9876543,123456 in some cases 8 digits and in others 6). I understand TextColumns for separating the contents however I would like to keep the downloaded file intact and then disect the contents of Column C into Column L-P. Suggestions? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
| cell contents | Excel Worksheet Functions | |||
| compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Threaded Mode
