Brett,

Take off the "--" from the front of my formula. That was to force
the returned value to be a number. If all you need is a string
=LEFT(A1,LEN(A1)-1) should work

Dan E

"supersonicf111" wrote in message ...
As ussual, I left out too many details.

Dan,

I forgot to include that some of the numbers start with a letter like
below, while the others are just numbers.

D12334
123456

And Steve, I am not following you.


Sorry!
Brett


---
Message posted from http://www.ExcelForum.com/