=MID(A1,2,25) in B1, and copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KimSingh" wrote in message
...
I have a set of rowe with info e.g S2345th, I need to remove the 's' for
each
row.... without manually edit each row & delete the 's'. Is there a
formula I
can use