Whatnot

Quick one, Excel, trim the last specific character from a cell =IF(RIGHT(A114,1)="*",LEFT(A114,(LEN(A114)-1)),A114) That is all

Here we go (H2): "Someplace XX8 8XX" =RIGHT(H2,(LEN(H2)-FIND(" ",H2))) kinda works, except if Someplace has additional spaces in it. Looks like you could do a find from the right to left and make it more fool proof but that would involve a bit of VBA.