Turn off Text to Columns

[Derek]

Has anyone else had this problem:
After using the Text to Columns Function the worksheet continues to split any text that I now copy and paste into a single cell. How does one turn it off so that text copied from a single cell pastes into a single cell?
Thanks in advance
Regards
Derek

 

[SIXTH SENSE]

hi derek!
i also got the same problem with you.all i do is close xcel and run it again. i hate to do that.! :x

 

[Yogi Anand]

Hi Derek and SIXTH SENSE:

What happens is that EXCEL remembers how DATA|Text_to_columns had been used earler in the same EXCEL session. So to be helpful, next time EXCEL automatically uses the setup that had been earlier used in the session.

So, if this is not what one wants, one can clear the DATA|Text_to_column settings -- by typing any text character in a cell then activating DATA|text_to_columns, then say choose the Delimited option and clear all of the Delimiters setting boxes.

And EXCEL now has a refreshed setting -- thus not requiring to close it and restarting it.

I hope this helps. If I have misunderstood your question -- my apologies!

 

[Derek]

Many thanks Yogi that's just what I was after!
Best wishes
Derek

 

[brucesmithde]

Hi Derek and SIXTH SENSE:

What happens is that EXCEL remembers how DATA|Text_to_columns had been used earler in the same EXCEL session. So to be helpful, next time EXCEL automatically uses the setup that had been earlier used in the session.

So, if this is not what one wants, one can clear the DATA|Text_to_column settings -- by typing any text character in a cell then activating DATA|text_to_columns, then say choose the Delimited option and clear all of the Delimiters setting boxes.

And EXCEL now has a refreshed setting -- thus not requiring to close it and restarting it.

I hope this helps. If I have misunderstood your question -- my apologies!

This worked perfectly for me in O365 Excel 2016. Thanks as I have been putting up with this for a long time since it has been an infrequent problem. But I finally got fed up and googled it and once again got my answer from Mr. Internet and Mr. Excel!
Thanks,
Bruce