27 Nov 2011 at 14:29 #2 Tomsk Tomsk Soldato Joined 18 Oct 2002 Posts 5,237 Location Overground, underground.. Code: =IF(RIGHT(TRIM(F2),1)=",",LEFT(TRIM(F2),LEN(TRIM(F2))-1),F2)
28 Nov 2011 at 14:15 #4 Participant Participant Caporegime Joined 13 May 2003 Posts 34,638 Location Warwickshire I was going to say you could use =SUBSTITUTE(F2,",","") but that removes all commas, not just trailing ones .
I was going to say you could use =SUBSTITUTE(F2,",","") but that removes all commas, not just trailing ones .