| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to seperate the the content of a cell by "," delimeter
i have a word file.
i need it to import this to an excel by using "," seperator |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to seperate the the content of a cell by "," delimeter
Save it from word as a .txt text file. Open that file from the Excel File/
Open menu, and Excel will allow you to specify a comma as the delimiter, and also allow you to specify the format of each column at the final stage of the text import wizard. -- David Biddulph "Kris Kan" <Kris wrote in message ... i have a word file. i need it to import this to an excel by using "," seperator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format a cell to make it blank if it's content is "N/A" | Excel Worksheet Functions | |||
| How can I "glue" a picture in a cell and treat it as content? | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Cond Format & helper-cell based "duplicate rec" tricked by content | Excel Discussion (Misc queries) | |||
Linear Mode
