Parsing a String (zipcode) [Excel 14/2010, VBA Only)

**lloydgodin** · 11-12-2012, 05:57 PM

I need help with the following code as I do not know how to read a string and return the 1st three values.

Please Login or Register  to view this content.

**rylo** · 11-12-2012, 06:05 PM

Hi

Please Login or Register  to view this content.

Assuming that there is something in iZip that is 3 or more characters long....

rylo

**shg** · 11-12-2012, 06:10 PM

One way:

Please Login or Register  to view this content.

**lloydgodin** · 11-12-2012, 06:17 PM

I am so LOL'ing at how simple the solution was.
I really appreciate the help. Thank you!!

Re: Parsing a String (zipcode) [Excel 14/2010, VBA Only)