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.

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

Speak Your Mind