Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

FIU Digital Project Guidelines and Help Materials

The internal standard operating procedures for FIU Libraries' digital collections

Combining Fields

Combing data across multiple fields is simple in Excel. All you need to do is create a formula using the "&" symbol between the fields you would like to combine. Here is a sample:

  A B C D
1 This is great ! =A1&" "&B1&C1

The result in cell D1 will read: This is great!

I've included " " between the A1 and B1 cells to insert a space between the words. You can insert any other letters, numbers, or symbols in your formula by including quotations.