Excel annoyingly remembers the last setting for Text to Columns.

Pick some dummy data and run T to C with no delimiters to reset to neutral.

Then paste your new paragraphs.


Gord Dibben MS Excel MVP

On Mon, 15 Jun 2009 23:41:02 -0700, PL wrote:

Thanks.
After experimenting it once,

all the paragraphs I paste onto the excel worksheet is separated into columns?

How to resolve this? Thanks

"Jacob Skaria" wrote:

If you have more set of numbers within brackets separated by space. the use
DataText to columnsSpace delimiter.. which will put that into separate
columns..Once done replace the brackets..

If this post helps click Yes
---------------
Jacob Skaria


"PL" wrote:

I have 2 sets of numbers in a single cell, separeated by brackets

Eg (123) (456)

I want to Separate them into individual cells using a formula, how do I do so?

Thank you