Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text Imprt from TAB to Comma
Hi All,
I've been scowering the web - looking for a way to turn the defualt import/conversion of a text/csv from TAB to Comma. Issue - if I double-click a file with the attribute .csv - the file opens in Excel, but every row is displayed in one column. If I have Excel open, and open the .CSV as a Text File - the import wizard starts and I am given the opportunity to change the delimiter from TAB to Comma. I'm guessing that the original issue (double-click on .csv file) is due to the default of the wizard being TAB. I'm not looking for the cheezie answers; 'change the files from .csv to ..txt' or adding a macro button. I am looking for a means to open the file natively and have the columns properly delimited. I'm on Windows XP and the client is using Excel 2000 (ok, upgrade is a valid suggestion). This is the only client I have where the .csv files do not open delimited. I looked in the Regional settings - everything appears to be properly configured. This client is multi-national, so there are many encoding selected. help where you can! (db) Daniel Bohner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Color Change prompted by different columns | Excel Worksheet Functions | |||
Can you change the Text Import Wizard column options | Excel Discussion (Misc queries) | |||
how i change thai text to english text | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
Paste comma delimited text into a spread sheet | Excel Discussion (Misc queries) |