I need to be able to concatenate blank cells without it showing a zero for
the cells that were true from an if statement but blank, or be able to record
a macro that prompts me for a cell reference or can find a range of
cells(A:AK) based on AL having certain text in it. Can anyone help??? I am
ready to scream.