Skip to Main Content

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.