change characters

  • Thread starter Thread starter RedFive
  • Start date Start date
R

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Conditional Formatting Amendment 2
Excel Summarization of indexed column 1
Cut the last 20 characters out of a text string 4
Data Validation - want to use symbols, but list is in orig font 2
Working Around 240 Character PRN Field Width Limit 1
Text to columns 2
Splitting data in a cell 2

Back
Top