View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Tab delimited to comma delimited

Thanks! It works fine to save it as CSV and then paste it back to notepad.
the problem is that the CSV format uses ";" as delimiter. I need ",". I know
I can search/replace but sometimes I have ";" in the text. Is there any way
to modify the delimiter? Thanks alot!

"David Biddulph" skrev:

Open the file in Excel specifying tab as the delimiter.
Save as CSV.
--
David Biddulph

"Arne Hegefors" wrote in message
...
Hi! I have a text file in notepad. The txt file is tab delimited. I want
to
transfor it to comma delimited. Is this possible by pasting the data to
Excel
and using some kind of "reverse text to columns"? Any idea? Thanks!