Hi,

Let's say I copy following text from some ASCII file and paste in to
excel.

Wer-67843-PLOU
Qty-34r5-ASDE

Then I use Excel's text to column feature on above and parse it with
Hyphen as delimter.

Wer 67843 PLOU
Qty 34r5 ASDE

Well and Good.

Next time I copy text with similar structure from ASCII file and paste
in to the ABOVE excel SESSION the parsing happens automatically.

Now, sometimes I would like this to happen automatically while
sometimes not (In the second case I have to go to the trouble of
starting new excel sessions).

Can this be feature be toggled on or off at user's whims?

Did MS DESIGN this auto parsing feature with a definite purpose?

Regards,
Hari
India