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.
Link to this post!