Text To Columns Function
 

Is it possible to use this funtion to parse data that contatins 2 delimiters :

" \ " and " = "

If not is there a way to do this via a formula ?

Thank you in advance.

Two methods
1. Carry out the conversion once using Other delimiter set to \. This will
give 2 columns of data. Chose column 2 and repeat process using Other
delimiter set to =

2. Do a search and replace of "=" with "\" first, then do the data to text
conversion in one hit.

--
Regards
Roger Govier
"carl" wrote in message
...
Is it possible to use this funtion to parse data that contatins 2
delimiters :

" \ " and " = "

If not is there a way to do this via a formula ?

Thank you in advance.

You can run it twice, and each time select where (which column) the data
should be placed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"carl" wrote in message
...
Is it possible to use this funtion to parse data that contatins 2 delimiters
:

" \ " and " = "

If not is there a way to do this via a formula ?

Thank you in advance.