Separate Cells

[PL]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[T. Valko]

Do you want to keep the ( ) ?

Are the numbers *always* 3 digits?

Will the numbers ever have leading 0s like 012 ?

 

[Jacob Skaria]

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

 

[PL]

Thanks.
After experimenting it once,

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

How to resolve this? Thanks

 

[Gord Dibben]

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