Hi

Thanks for the feedback. if you do have different length of characters
and want to return from the 2nd characters onward, try

=MID(A2,2,LEN(A2))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

I am an ordinary user trying to assist another

Thank You

cheers, francis



"ccdhofer" wrote:

I didn't try this, as I have differing numbers of characters, but thanks
anyway!!! The previous post got me to where I needed to be - but thanks for
taking the time!

"francis" wrote:

try
=MID(A2,2,5)

this assume that you always have 6 characters and you want the last 5

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

I am an ordinary user trying to assist another

Thank You

cheers, francis



"ccdhofer" wrote:

I want to eliminate the first character in several lines, but leave the
remaining characters. For instance, I use Excel as a "log book" and I have a
column that contains chronological numbers that, currently all begin with the
letter "S". (Example S7145A, S7145B, S7146A, etc.) I want to eliminate the
"S", but leave the remaining four digit number, with ending letter intact.
Considering my log bog is nearly 13500 lines long, I want to find a quick way
to do this. I am thinking of using Find and Replace, somehow, but cannot
figure out how to do, without completely clearing the cell. I am using Excel
2007.