Watch the video and then follow the steps below.

• Name your new column.
• Enter the formula by clicking on the field that needs to come first. Then type in & with " " (that creates a space). Then type in another & and click on the second field.

You want to do this with phone fields and the email fields. You will also want to do this with the name fields when working with People.

Click on the resulting value (1) in the previous step.

Scroll to the bottom of your file and click so that the whole column is selected.

• Click on Fill.
• Choose Down.

Here is an example of the values being filled down. With the same area selected, choose copy in the edit menu or type command-c (if on a mac) if on a PC do the equivalent to copy.

After you have copied the information you will see the Paste button become active.

• Click on the Paste button.
• Click on Values.

This will paste the resulting values so that when we delete the references (the fields used to make the calculation) we will retain the results.

Notice that a value shows up in the function bar rather than the formula that you saw in the previous step.