Here are the steps to follow in this lesson:
- Method #1 – Use the =CONCATENATE() Function Wizard.
- Text1 will be the cell reference for “First Name.”
- Text2 will indicate a SPACE between the 2 names. Type ” ” into the text2 indicator.
- Text3 will be the cell reference for “Last Name.”
- 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
Link to this post!
[…] Learn 2 ways to combine text from multiple cells […]