Hi,

Am an excel novice in many respects so this one is a bit beyond me.

I am creating a spreadsheet that will be flawed because of the format
of the data I will be using, but hopefully it will be capable of being
tidied up.

The spreadsheet will have three columns. In the first row it will have
a name in one cell, then a street name and number in the second cell
and a telephone number in the third.

In the second row there will be nothing in the first cell, the town in
the second cell and nothing in the third cell.

The third row will be blank.

So my question is, how do I set up some sort of repeating or looping
function to apply to the whole database? It would need to cut the town
from its cell in each instance, paste it to a new column alongside the
street name and number and delete the newly created blank row and the
existing blank row underneath it.

Thanks in anticipation.

T


--
Trickster
------------------------------------------------------------------------
Trickster's Profile: http://www.excelforum.com/member.php...o&userid=25374
View this thread: http://www.excelforum.com/showthread...hreadid=388553