Learn 2 ways to combine text from multiple cells into 1 cell

Here are the steps to follow in this lesson:

  1. Method #1 – Use the =CONCATENATE() Function Wizard.
  2. Text1 will be the cell reference for “First Name.”
  3. Text2 will indicate a SPACE between the 2 names. Type ” ” into the text2 indicator.
  4. Text3 will be the cell reference for “Last Name.”
  5. Method # 2 – Use the Ampersand (&) symbol in your formula e.g. =B4&” “&C4.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Trackbacks

  1. […] Learn 2 ways to combine text from multiple cells […]

  2. […] Text Functions help you to combine “Text Strings” […]

Speak Your Mind

*