Thread: Conditional concatenation and commas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_66_] Leith Ross[_66_] is offline
external usenet poster
  
Posts: 1
Default Conditional concatenation and commas

Hello Blasting Cap,

Here is another formula, This one doesn't care if "B" or "C" is blank.

=IF(AND(B1<"", C1<""), B1 & "," & C1, IF(B1="", C1, B1))

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=47763

Reply With QuoteReply With Quote