I've got a string of characters (city, state and zip) that is all
contained in 1 cell. I know how to separate them into different cells
using basic excel functions; i.e.,

Assuming data is in A27:
City
=Left(A27,Len(A27)-8)

State
=Mid(A27,Len(A27)-7,2)

Zip
=Right(A27,5)

The problem is that the character strings are in different rows; 1 set
of data is in Row 27 and the next is in Row 41. How do I increment the
rows by 14 using the formulas above?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/