| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use more than one "other" delimiter in excel
What shall I do if I have more than one type of "other" delimiters? For
example, both "" and "#"? Seems only one character is allowed in the import txt wizard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use more than one "other" delimiter in excel
You can only have one delimiter. Maybe you could pull the file into notepad
and change all the # to so there's only one. "vacaut" wrote: What shall I do if I have more than one type of "other" delimiters? For example, both "" and "#"? Seems only one character is allowed in the import txt wizard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use more than one "other" delimiter in excel
Or select the range and do Edit|Replace to change one of the delimiters to the
other. dlw wrote: You can only have one delimiter. Maybe you could pull the file into notepad and change all the # to so there's only one. "vacaut" wrote: What shall I do if I have more than one type of "other" delimiters? For example, both "" and "#"? Seems only one character is allowed in the import txt wizard -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| "carriage return" as the delimiter? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
