Paste this in colum B
=LEFT(A1,FIND("(",A1)-1)

Paste this in column C
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)



"Daniell" wrote:

The cell A has a catalog number in it with the order it belongs in the mix.
What I need to do is seperate the catalog number from the order number is
there a function or macro that will do this? Thanks in advance for the help.

A B C
A2399(1) A2399 1
A2418(2) A2418 2
A3625(10) A3625 10
A8697(8) A8697 8
A5867(11) A5867 11