Removing Line Breaks In A Cell:details within a range of cells

Good morning BladeUK

Not fully tested this but it seems to work OK.

Please Login or Register  to view this content.

It works for 4 line addresses, thus (say your address is in cell A1) :
=GetAddress1(A1,1) for line 1
=GetAddress1(A1,2) for line 2 etc up to line 4

You'll need to extend the code above to take account of 5 line addresses.

HTH

DominicB