View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Soth
 
Posts: n/a
Default HELP WITH FORMULA

Hi,

How do I split the state and the city into 2 column?

ie

column A ...............like to see in column B as State............Column
C as City
AZ-CHANDLER AZ
Chandler


Thanks
Soth