Conditions:
Cells in Column C
if len(selection) = 3, do cell.selection & "."
if len(selection) = 4, do cell selection & ""
Cells in Column D
if len(selection) = 2, do cell.selection & "....."
if len(selection) = 3, do cell.selection & "...."
if len(selection) = 4, do cell.selection & "..."
if len(selection) = 5, do cell selection & ".."
if len(selection) = 6, do cell.selection & "."
if len(selection) = 7, do cell.selection & ""
Cells in Column E
'(no conditions)
I need a macro to run through Column F that will concatenate the cells in columns C,D,E based on those conditions. The only problem is, I dont know how to write the code and only know the concatenate function and limited VBA. Any help? What commands do I use to a) combine the cell strings and b) do so based on these conditions?

I would appreciate any knowledge anyone might have. Thank you.
-Arthur Nazarian