LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding numbers shown in cells, not what is actually in cell - help!!! nelsonsdavis Excel Worksheet Functions 2 January 6th 07 08:22 PM
Copying to blank cells scorpiorc Excel Discussion (Misc queries) 3 December 6th 06 08:27 PM
Summing (or counting) cells until there is a blank cell Box815 Excel Discussion (Misc queries) 3 November 17th 06 03:35 PM
Why won't my cells change from Text to % or Numbers Ezlpo Excel Discussion (Misc queries) 3 October 3rd 06 07:00 AM
Autofilter a list of numbers and blank cells Cheryl Excel Discussion (Misc queries) 3 June 22nd 06 04:50 PM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"