How do I merge cells with different information?

[Linds]

I have 4 columns with information for seat locations (section, row, seat #,
seat #) and I need all four pieces of information in one cell. Is there any
function or trick for me to get these four pieces of data in one cell?

Right now I am typing in the row and seat numbers in the cell with the
section number and merging those. I have about 5000 accounts to do this with
and was curious of any shortcuts. Here is how I need the cell to read for
example:
106 BB 1-4.

Thanks!

 

[Max]

Assuming source data in cols A to D
In E1: =A1&" "&B1&" "&C1&"-"&D1
Copy down