Separate Cells
 

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

Separate Cells
 

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

Separate Cells
 

Do you want to keep the ( ) ?

Are the numbers *always* 3 digits?

Will the numbers ever have leading 0s like 012 ?

--
Biff
Microsoft Excel MVP


"PL" wrote in message
...
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

Separate Cells
 

With the number in A1 (123) (456); try

in B1
=SUBSTITUTE(LEFT(A1,FIND(")",A1)-1),"(",)+0
in C1
=SUBSTITUTE(MID(A1,FIND(" ",A1)+2,10),")",)+0

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

Separate Cells
 

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

Separate Cells
 

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