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:

=CONCATENATE(E2,"-",F2)

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”.

Posted in Tips and Tricks, Windows Tagged with: , , ,