Change certain numbers & blank cells into a letter

K

Kat

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!
 
E

Earl Kiosterud

Kat,

Put this in a nearby column. It's for testing the cells in column A. Change "A1" if
necessary. Copy down the column with the fill handle.

=IF(ISNUMBER(A1),"N",IF(A1="","R",""))

If your want a one-time permanent change to the original column (A), select the column
containing the formulas, Copy, then select column A, Edit - Paste Special - Values. now you
can get rid of the column containing the formulas.
 
Top