Thread: change characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
  
Posts: 747
Default change characters
Try this

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



On Sep 18, 11:11*am, RedFive
wrote:
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.
--
RedFive

Reply With QuoteReply With Quote