Excel’s Concatenate – Put strings together

Many times you have data in two separate columns that would really be better shown in a single column. Excel has a way to make this easy.  On the Formulas tab, click on the Text category.  On the list is the Concatenate command.

concatenate Function

concatenate Function

Select the Concatenate command and the Function Arguments box will open.

 

Concatenate

Concatenate

Select the cell you want to use for the first part of your concatenated string. In this example that is the first name.  Then we need to have a space between the first name and the last name. To create the space, simply click into the Text 2 field and press the space bar. This generates ” ” or the literal space.

Now click into Text 3 and select the last name cell. Notice each time you click into the last Text box a new one shows up. This will happen up to 255 times.  Now that you have the first name, space, and last name click the OK button and in your destination cell you will have the full name.

This technique works for text strings and numbers. So if you want to put City, State and Zip together, you can use the concatenate function to accomplish exactly that.

Check back for more shortcuts and tips to be more effective and efficient using Microsoft Office applications.

Advertisements

About sandyluedke

Sandy has been a successful realtor in North Texas for over 25 years. She was consistently a top 100 producer in Texas, with Remax for many years. Sandy founded Ideal Real Estate Group as a way to not only continue to do what she does best...selling and listing homes...but as a broker to share her vast knowledge by mentoring new or struggling agents.
This entry was posted in Business, Ideal Real Estate Group, Interests, Networking, Professional Business Networking, Real Estate, Sandy Luedke. Bookmark the permalink.

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s