View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default Excel 2002 : Quik way of getting customer name

Dear Sir,

I have a block of Credit Note reference and customer name separated by -
as illustrated

A
B

FAF CN NK000156 SUMISO S/B (PJVM) SUMISO S/B (PJVM)
FAF CN NK000133 - PANASONIC PANASONIC
FAF CN NK000154 - ATAMA LOGISTIC ATAMA LOGISTIC
FAF CN NK000158 - DNE LOGISTICS S/B DNE LOGISTICS S/B
FAF CN NK000155 - KUMISU YUKU SDN BHD KUMISU YUKU SDN BHD

May I know If there is a quick way of getting the full customer name just
behind the - as an output in columm B ?



Thanks

Low




--
A36B58K641