DefaultTableSeparator Property
Returns or sets the single character used to separate text into cells when text is converted to a table. Read/write String.
Note The value of the DefaultTableSeparator property is used if the Separator argument is omitted from the ConvertToTable method.
Example
This example changes the default table separator character.
Application.DefaultTableSeparator = "%"