Concatenating Various Values From Multiple Columns

[paulS30berks]

I am trying to concatenate values from seperate columns. Which is fine, however if there are no values in any of these columns I wish to include a dot (.). I also need to add a dot (.) inbetween values.

So for example

Column1 Column 2 Column 3

B11 Europe

would concatenate as:

B11.Europe.

 

[RuralGuy]

How about:
Column1 & "." & Column2 & "." & Column3