POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
 

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

POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
 

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

POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
 

Another way:

Copy column A to columns B and C
(3 columns that look identical)

Select column B
edit|replace
what: (*
with: (leave blank)
replace all

Select column C
Edit|Replace
what: *(
with: (Leave blank)
replace all

and one more
edit|replace
what: )
with: (leave blank)
replace all

If you really need a macro, you could record one when you do it manually.

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

--

Dave Peterson

POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
 

Thanks for the help

"Dave Peterson" wrote:

Another way:

Copy column A to columns B and C
(3 columns that look identical)

Select column B
edit|replace
what: (*
with: (leave blank)
replace all

Select column C
Edit|Replace
what: *(
with: (Leave blank)
replace all

and one more
edit|replace
what: )
with: (leave blank)
replace all

If you really need a macro, you could record one when you do it manually.

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

--

Dave Peterson