Cut off last character in a cell (Excel 2007)

Topic

New Reply

Hi,
I’m trying to come up with a formula that does as follows:
If the last character in a cell is * then cut that asterik off and leave the rest of the characters as is. For example, if cell A1 has 12345* in it, then I’d like my formula in A2 to result in only the 12345. Please note that the number of characters will be different throughout the database, so I can’t simply use the mid formula. Any ideas are always appreciated.
Thanks!
Lana

Reply | Quote

Replies

Never mind… I just figured it out… for those interested, here is my formula.
=LEFT(L751,(LEN(L751)-1))

Thanks!!
Lana

Reply | Quote

Your formula will cut off all last character in a cell, even those the last character is not a *

Try to use the following formula instead :

=SUBSTITUTE(A1,”*”,””)

Regards
Bosco

Reply | Quote

I like it…thanks!
Lana

Reply | Quote