Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text
Hi, I wonder if you can help?
When you import data from a text file to Excel you use a wizard that has three screens. The first screen asks you if the file is delimited and the second screen asks you for the delimiters. The default is Tabs but the data I import most often uses Semicolons, so I have to go to the second page and check the box for Semicolon. Is there a way to set the default delimiter to Semicolon so I do not have to go through that exercise all the time? -- Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text
Hi Paul
Is there a way to set the default delimiter to Semicolon so I do not have to go through that exercise all the time? As far as I know this is not possible but you can use a macro if you want. See this page http://www.rondebruin.nl/txtcsv.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul Hyett" wrote in message ... Hi, I wonder if you can help? When you import data from a text file to Excel you use a wizard that has three screens. The first screen asks you if the file is delimited and the second screen asks you for the delimiters. The default is Tabs but the data I import most often uses Semicolons, so I have to go to the second page and check the box for Semicolon. Is there a way to set the default delimiter to Semicolon so I do not have to go through that exercise all the time? -- Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text
Hi Ron-
This isn't a big help but I find that, if I do a Data, Text to Columns and specify the semicolon, then any text file imports I do after that the semicolon remains selected. Excel 2003 anyway. So you could 'prime' the text import wizard for an Excel session with this macro: Sub PrimeTextImport() Workbooks.Add ActiveCell.Value = "abc" Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Semicolon:=True ActiveWorkbook.Close False End Sub -- Jim "Ron de Bruin" wrote in message ... | Hi Paul | | Is there a way to set the default delimiter to Semicolon so I do not | have to go through that exercise all the time? | | As far as I know this is not possible | | but you can use a macro if you want. | See this page | http://www.rondebruin.nl/txtcsv.htm | | -- | | Regards Ron de Bruin | http://www.rondebruin.nl/tips.htm | | | "Paul Hyett" wrote in message ... | Hi, I wonder if you can help? | | When you import data from a text file to Excel you use a wizard that has | three screens. The first screen asks you if the file is delimited and | the second screen asks you for the delimiters. The default is Tabs but | the data I import most often uses Semicolons, so I have to go to the | second page and check the box for Semicolon. | | Is there a way to set the default delimiter to Semicolon so I do not | have to go through that exercise all the time? | -- | Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text
So you could 'prime' the text import wizard for an Excel session with this
You are correct Jim Thanks -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Rech" wrote in message ... Hi Ron- This isn't a big help but I find that, if I do a Data, Text to Columns and specify the semicolon, then any text file imports I do after that the semicolon remains selected. Excel 2003 anyway. So you could 'prime' the text import wizard for an Excel session with this macro: Sub PrimeTextImport() Workbooks.Add ActiveCell.Value = "abc" Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Semicolon:=True ActiveWorkbook.Close False End Sub -- Jim "Ron de Bruin" wrote in message ... | Hi Paul | | Is there a way to set the default delimiter to Semicolon so I do not | have to go through that exercise all the time? | | As far as I know this is not possible | | but you can use a macro if you want. | See this page | http://www.rondebruin.nl/txtcsv.htm | | -- | | Regards Ron de Bruin | http://www.rondebruin.nl/tips.htm | | | "Paul Hyett" wrote in message ... | Hi, I wonder if you can help? | | When you import data from a text file to Excel you use a wizard that has | three screens. The first screen asks you if the file is delimited and | the second screen asks you for the delimiters. The default is Tabs but | the data I import most often uses Semicolons, so I have to go to the | second page and check the box for Semicolon. | | Is there a way to set the default delimiter to Semicolon so I do not | have to go through that exercise all the time? | -- | Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text
In microsoft.public.excel.misc on Tue, 10 Jul 2007, Jim Rech
wrote : Hi Ron- This isn't a big help but I find that, if I do a Data, Text to Columns and specify the semicolon, then any text file imports I do after that the semicolon remains selected. Excel 2003 anyway. So you could 'prime' the text import wizard for an Excel session with this macro: Sub PrimeTextImport() Workbooks.Add ActiveCell.Value = "abc" Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Semicolon:=True ActiveWorkbook.Close False End Sub Thanks for this. Regards, -- Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing text-files | Excel Discussion (Misc queries) | |||
Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
Importing text into Excel... | Excel Discussion (Misc queries) | |||
Importing a text file | Excel Discussion (Misc queries) | |||
Help Importing Text File! | New Users to Excel |