Rodney Jorgensen
Active Member
- Joined
- Nov 9, 2007
- Messages
- 411
I need some help with either formulas or vba code to take a City, State, ZIP from one cell and split it into 3 cells.
So, Say I have this is Range("A1") = Rio Vista CA 94571-0157
how can I split this into 3 cells, say B1:D1?
I do believe I will always be working with the zip+5 and always the 2 digit state code.
Thanks for your help.
So, Say I have this is Range("A1") = Rio Vista CA 94571-0157
how can I split this into 3 cells, say B1:D1?
I do believe I will always be working with the zip+5 and always the 2 digit state code.
Thanks for your help.