LinkBack URL
About LinkBacks
=UPPER(IF(B2="United Kingdom",IF(LEN(SUBSTITUTE(A2," ",""))>=5,LEFT(SUBSTITUTE(A2," ",""),LEN(SUBSTITUTE(A2," ",""))-3) & " " & RIGHT(SUBSTITUTE(A2," ",""),3),A2),"")
Regards
=UPPER(IF(B2="United Kingdom",IF(LEN(SUBSTITUTE(A2," ",""))>=5,LEFT(SUBSTITUTE(A2," ",""),LEN(SUBSTITUTE(A2," ",""))-3) & " " & RIGHT(SUBSTITUTE(A2," ",""),3),A2),"")
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks