If function

[Brian]

I'm trying to get "if" to return a true blank, not a no
text.

no text = if(2=3,"anything","")

The problem is that the "" will leave a label prefix in
the cell. I need a true blank.

Any solution?

Thanks,

 

[J.E. McGimpsey]

A formula will return *some* value, not a blank. A cell with a
formula in it is by definition not blank.

What are you trying to do? It's likely to be something that is
freqently answered. Try searching the archives:

http://google.com/advanced_group_search?q=group:*excel*

 

[Brian]

I'm trying to create a simple interface template where we
dump the output from one system into a workbook and it
creates an upload for our GL. The GL upload can't contain
anything but valid entries and blank lines.

I tried the copy>paste special>values with the "skip
blanks box checked but that didn't do it.

This will be performed by clerical staff so I didn't want
to complicate the procedure beyond copy/paste with the
filtering and editing that seems to be necessary.

 

[Dave Peterson]

Since you seem ok with doing more work....

use a formula like:

=if(2=3,"anything",na())

Then convert to values (just copy|paste special|values)
then get rid of the #n/a's.

Edit|Replace
#n/a
with
(leave blank--no space, no nothing!)