Thread: If part of a cell = "NVA" then insert "Norfolk" in return cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RNCKWMN RNCKWMN is offline
external usenet poster
  
Posts: 1
Default If part of a cell = "NVA" then insert "Norfolk" in return cell
Column C has various 8 character codes (city & state abbreviations). One #
and 7 alpha. If the 2nd, 3rd & 4th characters = "NVA" then I want it to
return "Norfolk" in a Column J... if they = "RVA" it should return "Richmond"

Column C Column J
0NVARIVA should yield Norfolk
2RVACFVA should yield Richmond
1SNCEUNC should yield Selma

What formula or function do i use to make this happen?
Reply With QuoteReply With Quote