Take the 2-minute tour ×  The addresses are in once column, and
the only seperator between addresses is an empty row. I have
5000 addresses and each has approx 4 - 6 fields seperated by
rows. The data is pre-formatted from another system.  Anyone
know if this can be seperated out into columns per address? I
was thinking a macro may do it, but I think the problem is too
complex for text-to-columns or any other basic formula.
share|improve this question add comment  1 Answer  You might be
able to use RealCool Import Manager to do this. It lets you
identify recurring fields in a text file (see this screenshot)
as fields, then parse the file to extract them into separate
Excel columns.  share|improve this answer add comment  Your
Answer