Blog

How do I concatenate two fields in Excel?

To concatenate two fields in Excel you must need to read this article carefully. by KulfiSoftware.

STEPS:

If you’re only combining two cells, the ampersand “&” is the easiest way – as mentioned by Vitor Barreto, but if you’re combining more than two there are a few functions you could use.

If you’re using the latest version of Excel, try out the TEXT JOIN function. It’s like Concatenate, but so much better, as :

• You can specify a range of cells (i.e. A1: A30), rather than having to specify each cell individually,
• You can define a delimiter (i.e. insert a comma between results), and
• You can tell it how to handle blank cells (i.e. ignore them or not).

Try it out. It’s really quite cool.

Share