Thread: Parse ST-ZIP Cell (15,427 times...)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Selvarathinam
 
Posts: n/a
Default Parse ST-ZIP Cell (15,427 times...)
Put the following formula in the column B & C, they will provide u the
state in the column B & zip in the column without any spaces
B C
=TRIM(LEFT(A1,2)) & =TRIM(RIGHT(A1,5))
NY 10023

Hope the above solution will help u.

---
Selvarathinam.

Reply With QuoteReply With Quote