change characters

[RedFive]

I need to change the last character in a whole column from a "0" to an "h".
I'm sure there is a way to do this, just can't recall it.

 

[muddan madhu]

Try this

=SUBSTITUTE(A2,RIGHT(A2,1),"h")

 

[RedFive]

Didn't work for me, got an error when I tried to put in the formula. But I
think I answered my own question. This seemed to work for me:

=REPLACE(A2,7,1,"h")

Thanks for your help though, I really appreciate it.