Excel Join Character Strings From Multiple Cells
In Microsoft Office Excel you can join multiple string from cells by using the Concatenate function. Like this:
Here the string from the cell E2, the character “-” and the string from F2 will be joined together. Making a final result looking like this: “7-42”.