Thanks Tom


-----Original Message-----
=Trim(Substitute(A1 & ", " & C1 & ", " & D1 & ", " & E1
& ", " & F1 & ", " &
G1 & ", " & B1,char(160)," "))

--
Regards,
Tom Ogilvy




"Pete" wrote in
message
...
Thanks that has worked great is there a way to ensure
all
spaces other than 1 following a comma should be ommited
as I have great big spaces in the address now!


.