|I have been strugling with a problem and would like some help if possible.|
I have 3 columns.
A, D and E
E contains the concatenation of A and D,
A could be xx and D could be yy or either could be a blank.
IF both are blank Column E would be blank
IF only D is populated E would show the content of D
If both A and D are populated the E would show D (A) That is D and A are concatenated with a bracket around column A's content.
Title maybe confusing I meant cells not rows