In a recent Excel question I was given a formula to use which worked very well and I'm so greatfull it did because it got us out of a huge bind.

LEFT(TRIM([Test]),LEN(TRIM([Test]))-6) & IF(LEN(TRIM([Test]))>6," ","") & RIGHT(REPLACE(TRIM([Test]),".",","),6)

I was just wondering why so many TRIM functions were used on the Test variable. is this standard procedure to make sure the numbers don't get messed up by extra spaces etc?