I am using Concatenate in a calculated column to combine information from two columns in a list like this =CONCATENATE(A2, ", ",B2," feet"). Can you help me with a formula that would leave the field blank when the respective cell for column A is blank instead of returning ", feet"? Column B would always be empty if column A is empty.
Just add a conditional check for column A to be blank.
=IF(A<>"",CONCATENATE(A,", ",B, " feet"),"")
If A isn't blank, it'll return the concatenation, otherwise it returns an empty string.