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