I have a spreadsheet with 3700 rows. Column B contains a city code and Column E contains the actual location number. I am trying to get all output to look as follows 050-0000
I have included an excel sampl spreadsheet as well. My source is in yellow I am trying to concatinate or merge as the green cells.