Text Functions | The Company Rocks - Page 2

Danny July 23, 2008 Leave a Comment

Use the =TRIM() Function to eliminate unnecessary space inside a cell

Here are the steps to follow in this lesson:

When we wrote the formula =B4&” “&C4&” “&D4) we found an unnecessary blank space between “First Name” and “Last Name” when the cell reference for “Middle Name” was blank.
Edit that formula by using the =TRIM() Function to remove the extra space in the resulting cell.

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.

Share and Enjoy:

Filed Under: Excel Functions, Excel Training, Text Functions Tagged: Remove empty spaces in a cell, Trim() Function, Video lessons for Excel

Danny July 22, 2008 2 Comments

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

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

Share and Enjoy:

Filed Under: Excel Training, MS Excel Training, Text Functions Tagged: Ampersand Operator, Concatenate, Video lessons for Excel