Thread: assigning numbers to companies
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jamesea jamesea is offline
external usenet poster
  
Posts: 8
Default assigning numbers to companies
I need to assign companies to one of four different numbers depending on
where they fall in the alphabet, for example I need to assign a company "care
homes ltd" as 01. Any ideas on the formula?


01 A GR
02 GS SA
03 SB THEC
04 THED Z

Reply With QuoteReply With Quote