H
HeatherJ
I need a formula (will be in L2) to do the following--
IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2
H2 separated by commas.
If G2 does not contain the text "bail" then I want L2 to remain blank.
Any help would be appreciated. Thanks! Heather
IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2
H2 separated by commas.
If G2 does not contain the text "bail" then I want L2 to remain blank.
Any help would be appreciated. Thanks! Heather