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.
|