Change Default Delimiters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How do I change the default delimiters in Excel 2007? I want to add ';' and
',' to the default delimiters instead of selecting it every time I import
files.
 
I don't get it. I haven't programmed since C++ in college. Is there a way for
me to adjust the defaults in Excel so that it will be in effect for all
imports as well as new workbooks or do I have to use code?
 
From a old thread with Jim Rech:
This is the only way as far as I know
******************************

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
 
Ok. I'll give coding a try. Thanks Again!

Ron de Bruin said:
From a old thread with Jim Rech:
This is the only way as far as I know
******************************

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
Click to expand...
 
Back
Top