The trick I use for temporarily changing formulas to text is to replace "=" with "$=". That stops Excel from getting confused between text that begins with "=" and formulas (that always begin with "=").

Try:
1. Replace "=" with "$="
2. Text-to-columns using whichever delimiter your Excel uses
3. Replace "$=" with "="