#### cvgreports

##### Board Regular

- Joined
- Jun 28, 2006

- Messages
- 50

I hope that made sense. Here is an example...say I have the following 5 numbers:

8014554

45678456

87451245

0008014554b

0008014554c

And what I need my formula to do provide is the following results instead:

8014554

45678456

87451245

8014554

8014554

So far I have started with the following =LEFT(A1,LEN(A1)-1), but that will always remove the last character (number and letter). And I don't know what do next, so I'm lost.

Thanks in advance.