ExcelBanter - using multiple delimiters at the same time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - using multiple delimiters at the same time (https://www.excelbanter.com/excel-discussion-misc-queries/102559-using-multiple-delimiters-same-time.html)

[email protected]

using multiple delimiters at the same time

Hi,
I have 3 columns in my excel sheet and I would like to use multiple
delimiters (for ex: tab and comma) at the same time to separate these
columns. Could anyone suggest a way of doing it?
Thanks,

Bernard Liengme

using multiple delimiters at the same time

More detail needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
Hi,
I have 3 columns in my excel sheet and I would like to use multiple
delimiters (for ex: tab and comma) at the same time to separate these
columns. Could anyone suggest a way of doing it?
Thanks,

Dave Peterson

using multiple delimiters at the same time

Like when you're using data|Text to columns|delimited???

If you mean that, then you can choose the tab and comma when you're in that
dialog.

wrote:

Hi,
I have 3 columns in my excel sheet and I would like to use multiple
delimiters (for ex: tab and comma) at the same time to separate these
columns. Could anyone suggest a way of doing it?
Thanks,

--

Dave Peterson

All times are GMT +1. The time now is 02:55 PM.