Thread: POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daniell Daniell is offline
external usenet poster
  
Posts: 15
Default 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
Reply With QuoteReply With Quote