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

Here are the steps to follow in this lesson:

1. 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.
2. 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.