Thread: Is It False ??
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Is It False ??

Not really, since there is not EVALUATE worksheet function.

But, kinda, if you use the formula

="=" &A1 & A2 & A3 & A4

and then select the cell, press F2, Shift-Home, F9, F9 - it will then
evaluate to False.

;-)
Bernie

"Gary''s Student" wrote in message
...
In A1 thru A4 I have:

1
=
2

In A5 I have:

=A1 & A2 & A3 & A4
which displays =1=2

Is there any way I can evaluate this (should be False) without using VBA ?

--
Gary''s Student - gsnu2007xx