Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change certain numbers & blank cells into a letter
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. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Kat" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding numbers shown in cells, not what is actually in cell - help!!! | Excel Worksheet Functions | |||
Copying to blank cells | Excel Discussion (Misc queries) | |||
Summing (or counting) cells until there is a blank cell | Excel Discussion (Misc queries) | |||
Why won't my cells change from Text to % or Numbers | Excel Discussion (Misc queries) | |||
Autofilter a list of numbers and blank cells | Excel Discussion (Misc queries) |