Nifty Tip: Using the CONCATENATE Formula

The CONCATENATE formula allows one to combine text from multiple cells into a single cell. The CONCATENATE formula is in the Text category in the Insert Function dialog box.

To add a blank character between words, type a space between quotation marks. This adds a blank character between the separated text. Whatever is between the quotes, be it a space, text or characters, it will show up in the concatenation.

So, if you were trying to create an email address at Dartmouth College, the formula would be:

=CONCATENATE(A3,”.”,B3,”@dartmouth.edu”)

Which would yield: Mickey.Mouse@dartmouth.edu

Author: Noël Figart

Noël Figart is a computer applications instructor, technical writer and editor.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.