Complete Excel Guide

You will find all the information regarding Excel.

Friday, 25 August 2017

TRIM Function

TRIM Function

Trim function is used to remove the extra spaces in the text.

Syntax: TRIM(text)
Example: =TRIM("Long     Long ag   o")
Result: "Long Long ag o"

Posted by Unknown at 11:50
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: formulas to remove extra spaces, how to remove extra spaces in text in excel, trim formula, trim function, trim() function

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ▼  2017 (37)
    • ►  September (8)
    • ▼  August (29)
      • NOW & TODAY Functions
      • TIME Function
      • DATE Function
      • Date & Time Functions List
      • TEXT Function
      • SUBSTITUTE Function
      • REPLACE Function
      • MID Function
      • PROPER Function
      • FIXED Function
      • T Function
      • SEARCH Function
      • REPT Function
      • RIGHT Function
      • TRIM Function
      • UPPER Function
      • LOWER Function
      • LEFT Function
      • LEN Function
      • Find Function
      • EXACT Function
      • DOLLAR Function
      • CONCATENATE Function
      • CODE Function
      • CLEAN Function
      • CHAR Function
      • BAHTTEXT Function
      • Text Functions
      • Types of Functions in ExcelText Function  Date ...
Hit Counter
Ethereal theme. Powered by Blogger.