Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab delimited to comma delimited
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab delimited to comma delimited
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab delimited to comma delimited
Excel picks up this delimiter from a windows setting.
Go to the control panel, regional and language options (in winXP Home) Regional options tab click the customize button On the Numbers tab, change the list separator to what you want. Most people in the USA use a comma. Most(?) people in Europe use the semicolon. You may want to change it back when you're done. Arne Hegefors wrote: 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
Comma delimited bank info | Excel Discussion (Misc queries) | |||
Comma delimited question | Excel Discussion (Misc queries) | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) |