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!