Text To Columns Function

C

carl

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

Roger Govier

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

RagDyeR

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!
==============================================

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