Thread
:
Data displayed that is not equal to FALSE in a row
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
Posts: 11,058
Data displayed that is not equal to FALSE in a row
=SUBSTITUTE(A1&B1&C1&D1,FALSE,"")
--
Gary''s Student - gsnu201001
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student