Thread: Data displayed that is not equal to FALSE in a row
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mally Mally is offline
external usenet poster
  
Posts: 73
Default Data displayed that is not equal to FALSE in a row
Thanks Gary. That works great!

"Gary''s Student" wrote:

=SUBSTITUTE(A1&B1&C1&D1,FALSE,"")
--
Gary''s Student - gsnu201001
Reply With QuoteReply With Quote