Text To Columns Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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