Cliphead Pilchard Joined Nov 30, 2005 Messages 9,679 Likes received 131 Thanks received 12 Location 55°51'N, 04°12'W Apr 28, 2013 18:59 #11 Thanks all for the help. Job done and newsletter (spam ), on the way.
Spacecadet Double Godlike! Joined Mar 22, 2006 Messages 12,451 Likes received 53 Thanks received 16 Location Jupiter Apr 28, 2013 21:04 #12 Bit late but this formula would have helped: Code: =IF(LEN(A1)-IFERROR(FIND(".co.uk",A1),0)=5, ".co.uk","")
Bit late but this formula would have helped: Code: =IF(LEN(A1)-IFERROR(FIND(".co.uk",A1),0)=5, ".co.uk","")
vetran My post count is Majestic Joined Jul 6, 2005 Messages 52,798 Likes received 15,890 Thanks received 4,905 Location Come Friendly Bombs May 7, 2013 23:30 #13 real men use AWK!