POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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.
 
Thanks for the help

Dave Peterson said:
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.
Click to expand...
 
Back
Top