First Last name combination

There are a lot of extra columns in default contact lists, and many of them never get used.

For Example, by default First Name, Last Name, and Full Name are three different fields.  Most people skip entering the Full Name field to avoid the double data entry.

A simple formula in a new calculated field can create a full name and prevent the double entry.

Combine ColumnsCalculating Full Name

First, you’ll need to delete the default Full Name column so that you can recreate it with a calculated column type.  Go to list settings. Click on the Full Name column, and then click the delete button.

Then, create a new column by clicking “Create Column” on the List Setting Page.  Name the column “Full Name” and choose “Calculated” for column type. Use the formula [First Name]&”  “&[Last Name] and click OK.

The Full name field will now be automatically filled in.

Comined Names

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s