Select range then hit F5 Special Blanks OK out Edit Delete Shift
cells left OK out


"Andy in Edinburgh" wrote:

Hi

I have a list of addresses some of the addresses have more lines in them
than others see below.

A B C D E
Mr Smith 5 example St. Hassocks W Sussex BN3 7HJ
Mr Jones 22 Hope Road London SW19 1QW

The list is approximately 700 rows long.

Is there a formula that would move up the lines of the address so they are
all in adjacent cells e.g.
A B C D E
Mr Jones 22 Hope Road London SW19 1QW

Thanks

Andy