Thread: Formula to Separate City, State, Zip
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim May[_3_] Jim May[_3_] is offline
external usenet poster
  
Posts: 16
Default Formula to Separate City, State, Zip
in article , Havenstar at
 wrote on 10/15/08 3:32 PM:

City, State, Zip
For city =LEFT(A1,FIND(",",A1)-1)

For state =MID(A1,FIND(",",A1)+2,2)

For zip =RIGHT(A1,5)

Hope that helps,

Jim

Reply With QuoteReply With Quote