Excel Trim function is very useful function that removes extra spaces from data. This formula removes all spaces from data except for single space between words. While validating data on the basis of, the trim function can give you valid length by removing spaces from beginning, spaces from end and extra spaces between words.

This can be useful for refining raw data received from any external application with irregular spacing.

The Microsoft Excel TRIM function returns a text value with the leading and trailing spaces removed. You can also use the TRIM function to remove unnecessary spaces between words in a string. The TRIM function is a built-in function in Excel that is categorized as a String/Text Function.

Syntax

  • Getting length of characters within a cell with cell reference:
  • =LEN(Cell Reference)
  • Getting length of a long string:
  • =LEN(“string”) (value needs to be kept within quotes)
author image

About admin

You Might Also Like...

Excel Count Function
Excel Macro Training Details
CSS Selectors

2 Comments

  1. I was pretty pleased to find this great site. I need to
    to thank you for ones time for this particularly wonderful read!!
    I definitely loved every bit of it and i also have you
    saved to fav to see new things on your web site.

  2. Everything is very open with a precise explanation of the issues.

    It was truly informative. Your site is very helpful.

    Many thanks for sharing!

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2017/03/17/excel-trim-function
YouTube79
YouTube