Thread: Conditional concatenation and commas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] twox4s@yahoo.com[_2_] is offline
external usenet poster
  
Posts: 8
Default Conditional concatenation and commas
BC: Try this:

=IF(OR(ISBLANK(B1),ISBLANK(C1)),CONCATENATE(B1,C1) ,CONCATENATE(B1,",",C1))

Mark

Reply With QuoteReply With Quote