Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Saz Saz is offline
external usenet poster
 
Posts: 15
Default If values of Cell are Null...........

Hi,

If any values of cell in column C are null, how can I update fill null
values to word 'UNKNOWN'?

Thank you,
Saz
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,480
Default If values of Cell are Null...........

Hi Saz

Mark the range of column C that you wish to use.
Press F5SpecialBlanksOKtype unknown into first highlighted cellpress
Control+Enter
--
Regards
Roger Govier

"Saz" wrote in message
...
Hi,

If any values of cell in column C are null, how can I update fill null
values to word 'UNKNOWN'?

Thank you,
Saz


Reply
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
Trouble with null values Tazzy via OfficeKB.com Excel Worksheet Functions 6 December 6th 07 11:23 AM
Null values need to be replaced Hey Excel Discussion (Misc queries) 3 February 7th 07 03:22 AM
sum if - null values DC Excel Discussion (Misc queries) 1 October 16th 06 05:56 PM
cell value based on null/not null in another cell spence Excel Worksheet Functions 1 February 18th 06 11:49 PM
return a " " for null values David# Excel Worksheet Functions 2 January 21st 05 06:47 PM


All times are GMT +1. The time now is 11:26 AM.

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"