Concatenate cells with underscore in between

Question

I want to be able to combine 4 cells and in between each cell have an underscore be entered in and then the result be entered into a new cell.

Example: Joe Smith California 12/12/1975

joe_smith_california_12/12/1975 ((for this to end up in a new cell))

Do you know how to go about this?

Answer

Anyway, if your data is in A1 to D1 then

=A1&"_"&B1&"_"&C1&"_"&D1

or

=Concatenate(A1,"_",B1,"_",C1,"_",D1)