Thread: Data, Text to Columns, has commas in the text, plus as a delimeter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tonso Tonso is offline
external usenet poster
  
Posts: 90
Default 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
Reply With QuoteReply With Quote