How to insert a character in a formula?

[delvillardennis]

I found a formula from an excel file as shown below:


=IF(OR(VLOOKUP($G9,Data!$C$5:$L$44,2+Data!$N$1,FALSE)>W$8,(VLOOKUP($G9,Data!$C$5:$L$44,2+Data!$N$1,FALSE)+VLOOKUP($G9,Data!$C$5:$L$44,3+Data!$N$1,FALSE)-1)<W$8),"",IF((W$8-VLOOKUP($G9,Data!$C$5:$L$44,2+Data!$N$1,FALSE))/VLOOKUP($G9,Data!$C$5:$L$44,3+Data!$N$1,FALSE)>=VLOOKUP($G9,Data!$C$5:$L$44,10,FALSE),1,"██"))


I am curious and want to know the technique in inserting the character (i.e. the black square in close quotations) in the a formula.


Thanks in advance.

 

[delvillardennis]

I found the answer here: http://chandoo.org/wp/2010/10/11/insert-symbols-in-excel-howto/


mea culpa...