Thread: Formula Help
View Single Post
  #1  
Old June 2nd, 2010, 04:26 PM posted to microsoft.public.excel.worksheet.functions
HeatherJ
external usenet poster
 
Posts: 25
Default Formula Help

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