View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kat Kat is offline
external usenet poster
 
Posts: 56
Default Change certain numbers & blank cells into a letter

A long column of mixed blank cells, and single numbers from 1 to 7. I need
to change the blank cells to the letter R, and the numbers to the letter N.
Spent much time browsing the posts but couldn't find. Would love if someone
could help me asap.. I'm not a very skilled excel user! Thanks so much
experts!
--
Kat