Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"go to" "blanks" after using a formula
I am having an issue where i have used a formula such as =if(C2=1,"True",""),
if ill down an entire column, then I copy and paste the data in that column as values. If i then try to use Go To.., Special, Blanks, these empty fields (that the above formula would have put as "") are not selected. This has worked this way in every edition of excel that i have used. Why does excel not consider these as "blank" fields when they show nothing in the cell and nothing in the formula bar? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"go to" "blanks" after using a formula
Johnny Boy,
Well, they're not blank, since you have a null string "" in them. If you want, you could change your formula to =IF(C1=1,True,"") And then after you do your copy paste values, use Edit / go to / special / constants and choose strings (uncheck the others) . That will select all the "" values, and leave the TRUE ((boolean values, or what Excel considers logical expressions) alone. HTH, Bernie MS Excel MVP "jhnnyboy247" wrote in message ... I am having an issue where i have used a formula such as =if(C2=1,"True",""), if ill down an entire column, then I copy and paste the data in that column as values. If i then try to use Go To.., Special, Blanks, these empty fields (that the above formula would have put as "") are not selected. This has worked this way in every edition of excel that i have used. Why does excel not consider these as "blank" fields when they show nothing in the cell and nothing in the formula bar? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"go to" "blanks" after using a formula
This is a case of semantics between the words blank and empty.
F5SpecialBlanks really means F5SpecialEMPTY CELLS A cell that contains a formula blank is not an empty cell. A formula blank is an empty TEXT string. If you convert that to a constant by using CopyPaste SpecialValues the cell *still contains the empty text string* so the cell *is not empty*. -- Biff Microsoft Excel MVP "jhnnyboy247" wrote in message ... I am having an issue where i have used a formula such as =if(C2=1,"True",""), if ill down an entire column, then I copy and paste the data in that column as values. If i then try to use Go To.., Special, Blanks, these empty fields (that the above formula would have put as "") are not selected. This has worked this way in every edition of excel that i have used. Why does excel not consider these as "blank" fields when they show nothing in the cell and nothing in the formula bar? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |