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

=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

You can do a right function (i.e. +right(a1,6) and it will put 2345th in the
new cell).

"KimSingh" wrote:

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

You could use Text To Columns.

Select a column of your data, then:
<Data <TextToColumns,
And check "Fixed Width", then <Next,
Click in the "Data Preview Window" and drag the "Break Line" to separate the
"S" from the rest of the data.
Then <Next,
Then click on "Do Not Import Column",
Then <Finish

And you're done!

Now, the advantage of using TTC is that you are left with actual data.
There are no formulas in the cells, which *might* have to be removed before
you could continue.

The disadvantage of TTC, is that if you add similar data on a continuing
basis, you would have to repeat the process all over again, where if you had
installed text formulas, they would *automatically* correct your data as you
entered them.

Now you have a choice of which wayt you wish to go.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"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