instead of
etc![]()
=A1 & vbNewLine & B1 & vbNewLine & C1
use
......etc![]()
=(if(left(A1.value,1)<>"#",A1 & vbnewline, "") & if(left(A1.value,1)<>"#",B1 & vbNewLine,"") &
instead of
etc![]()
=A1 & vbNewLine & B1 & vbNewLine & C1
use
......etc![]()
=(if(left(A1.value,1)<>"#",A1 & vbnewline, "") & if(left(A1.value,1)<>"#",B1 & vbNewLine,"") &
If someone has helped you then please add to their Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks