| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data, Text to Columns, has commas in the text, plus as a delimeter
Using XL 2003, I want to import data from another program. I can do so
with the Text to Columns feature, but, the program uses exclamation points and a comma as a delimeter ( !,! ). An example is below: !Visit Arizona, Eat Mexican Food!,!1!,!1.000!,!N!,!50!,!50!,!0!,! 2229!,!547!,!188!,!0!,!0!,!0!,!0!,!0!,!0!,!N! As you can see, commas are sometimes used in the text, plus as a delimeter. How can I handle this? Thanks, Tonso |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Excel 2007 convert into tab delimeter text file with extra tab spa | Excel Discussion (Misc queries) | |||
| Converting excel 2007 to tab delimeter text file | Excel Discussion (Misc queries) | |||
| text wrap delimeter | Excel Discussion (Misc queries) | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
Threaded Mode
