Help with formula

[Mike Kiekover]

I apologize if this is a duplicate. I don't see the original in my sent folder, so nor sure what happened.

I need to modify the following formula so that the final -[E13] is associated only if E13 contains a value. I would greatly appreciate assistance.

Mike K

=CONCATENATE(B13,"-",C13,"-",D13,"-",E13)

 

[FloMM2]

Mike,
If I understand you... if cell [E13] is empty you do not want to
concatenate this cell has a value in it.
The formula looks something like:
=IF(E13<>"",CONCATENATE(B13,"-",C13,"-",D13,"-",E13),CONCATENATE(B13,"-",C13,"-",D13))
However, if you want the cell to be empty if cell [E13] is empty, it would
look like :
=IF(E13<>"",CONCATENATE(B13,"-",C13,"-",D13,"-",E13),"")
HTH,