Concatenate multicoulmns but not display blank coulmns in the total formula

[NGB82KS]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]SURNAME[/TD]
[TD]FIRSTNAME[/TD]
[TD]MI[/TD]
[TD]GENQUAL[/TD]
[TD]CONCAT'D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]DOE[/TD]
[TD]JOHN[/TD]
[TD]T[/TD]
[TD]JR[/TD]
[TD]DOE.JOHN.T.JR[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]DOE[/TD]
[TD]JANE[/TD]
[TD][/TD]
[TD][/TD]
[TD]DOE.JANE[/TD]
[/TR]
</tbody>[/TABLE]

I cant figure out how to write a formula to concatenate column B thru Column E, add a period after each column, but not display a period if the field is blank. In the example, row 2 shows the full display with a "." after each and row 3 displays jane but no "." after because the other fields are blank.

 

[mohadin]

Try

E2=A2&"."&B2&IF(C2<>"","."&C2,"")&IF(D2<>"","."&D2,"")

 

[NGB82KS]

It returned a "FALSE" in the Column.
so it should be checking to see if Column "D2" has text, if it does it adds the "." and the text of D2 and repeats on "E2" with the same process. If one field is blank it moves to the next so if they have no MI in Column "D" but a generation qualifier of "Jr" it would add 1 "." and the "JR" from that field.

=CONCATENATE(F2=B2&"."&B2&IF(C2<>"","."&C2,"")&IF(D2<>"","."&D2,""))

 

[Fluff]

What version of Xl are you using?

 

[mohadin]

No
Just put the formula as it is
=A2&"."&B2&IF(C2<>"","."&C2,"")&IF(D2<>"","."&D2,"")

 

[NGB82KS]

2016

 

[Fluff]

That's a shame, if you had 2019 or 365 I'd suggest
=TEXTJOIN(".",1,A1:D1)

As it is, mohadin's formula should work, as long as both Col A & B always have text.

 

[NGB82KS]

That was is it, thanks Mohadin!!! Life saver!

 

[mohadin]

You are very well come and thank you for the feedback
Be happy