Concatenate – Fancy Word, Simple Meaning

Concatenation Formula

Concatenate is one of many fancy words we learn while working in litigation support. It is a technical term and it is a verb defined as “to link (things) together in a chain or series.”

Most of the time we are using concatenation to piece together multiple values. We also have the ability to insert additional values “in between” the original values.

We use concatenation techniques within many software tools, but for this explanation I will use Excel.

In this first example, we have address fields that are currently separate values and we need to concatenate them into one full address. Using this concatenation formula, we are almost there, but we are missing the spaces between the values. All of the values are running together and look messy.

Concatenate

In the example below, we are performing the same concatenation as above, however we are using the CONCATENATE function instead. We are still missing spaces between the values.

Concatenate

In the example below, we are using the ampersands and we concatenate some punctuation to make the result look nicer.

Concatenate

In the example below, we are performing the same concatenation as above, however we are using the CONCATENATE function instead.

Concatenate

In the example below, we are concatenating the first name and last name into a “last name first” format and inserting a comma and space to make it look nicer.

Concatenate

In the example below, we are concatenating the file path and the filename and inserting a backslash in the middle.

Concatenate

Hopefully these examples give you an overview of the possibilities for concatenating values. We use this technique often when manipulating data in a litigation support role.

NOTE:  We are using ampersands or the CONCATENATE function to concatenate values. They both work, it is your preference.

    I am very passionate about helping legal professionals succeed. I even quit my day job to devote more time to mentoring! I want to encourage you to subscribe and join the LitSuppGuru community. I share humorous, informative, and time-sensitive emails above and beyond what appears on this site.

    Please note: I reserve the right to delete comments that are salesy, offensive or off-topic.

    • Tony Harvey-jones

      Amy if I had a laundry list of subjects that I wanted you to address this would be on the list

    • mgolab

      Another great tip Amy.

      Don’t you love dropping a word like concatenate into a conversation with a lawyer and for a few seconds you get a puzzled look from the lawyer as they are translating what you just said.

      If only Excel could handle larger datasets. Such a pain that it can currently only handle a ‘miniscule’ 1million rows.

      • How did you know, Matthew? I have done exactly that. It is a nice word to drop into a conversation and teach the attorneys.

    • Pingback: Fast Tip Friday - Batch Rename Using a Text File()