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


