Change certain numbers & blank cells into a letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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.
 
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

Excel Add ^ to a row of cells containing letters 3
Creating sequential numbers plus a letter 4
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Extracting numbers and letters in a single cell to separate cells 1
Excel Concatenate with line breaks but ignore blank cells 3
Excel 2007 changed the column Letters into numbers 1
Column headers numbers instead of letters 2
How to make a number have a certain number of characters. 5

Back
Top