Triming text

[JasonLeVan]

i AM CONSFUSED ON WHAT TO USE, I HAVE TEXT IN A COLUMN AND ALL I WANT TO DO IS TRIM THE LAST LETTER OR NUMBER OFF IT

 

[Brian Walters]

If you info is in cell A1, then in the B1 enter:

if you want just the last letter\number use =Right(A1,1)

if you want all but the last letter\number use = Left(A1,Len(A1)-1)