yes it is the 10th character. Where do I put this =replace code?

"Alan" wrote:

=REPLACE(A1,10,1," ")
I'm assuming that the 'S' will always be the 10th character or this wont
work,
Regards,
"McDal" wrote in message
...
I need to replace in all my thousands of part numbers.....position number
10
which is the letter "S" to a blank.

Does anybody know how to do this?