Text Function | How to use the Excel TRIM Function?



In the previous post, we saw ‘Text Function | How to use the Excel LEN Function?‘, now we will learn about ‘How to use the Excel TRIM function?’.

Where to Find the Text Function?

To find the text function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Text’ option as shown below:

excel lower function

You can also see the text function via shortcut key – press ‘ALT + M + T’ after that select the text function that you want to use.


What is Excel TRIM Function?

The Excel TRIM function removes all spaces from text except for single spaces between words. Use TRIM on the text that you have received from another application that may have irregular spacing.


Syntax

TRIM(text)


Arguments

The TRIM function syntax has the following arguments:

Text    Required. The text from which you want spaces removed.


Understand With Example

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function


For Latest Updates & Learning Join Our YouTube Channel: Join Now

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

UPI Transaction Limit Per Day JEE Mains Admit Card 2023 Released: Download Now RRB Group D Result 2022: नियुक्ति पत्र, JEE Main 2023: Registration Begin, Exam Date, How To Apply? Download And Install Tally Prime Free