enter formula to copy characters in a cell less last one

[BC@D]

[Bryan Hessey]

=left(a1,len(a1)-1)

of course, you may want to add a 'null data' test, and you may also want to drop the last character ONLY if it is an asterisk etc

=IF(LEN(A1)<1,"",IF(RIGHT(A1,1)<>"*",A1,LEFT(A1,LEN(A1)-1)))

Hope this helps

--