Formula to change content in a cell

[Robert]

select all cells to be changed
select from the menu "edit"
select "replace"
type in the replace box "m65"
type in the with what box "m6s"
select "replace all"
done

-----Original Message-----
Hi,
I have a column of vendor numbers such as m6501p01 in one

cell, the next record is m6501p02 and so on. The person
that entered the numbers should have entered an S instead
of a 5. I have over 100 records to change. Is there a
forumla that will change all the 5's in that position to
an S?

 

[Alan]

That was my first thought, but in potentially lengthy strings the same three
letters may turn up elsewhere