30 excel functions in 30 days - TRIM Function

I will be taking you to a simple guide on 30 Functions in my post's here.... So here is begin first function below:

TRIM:

The TRIM function removes all the spaces in a text string, except for single spaces between words.The TRIM function can help with the cleanup of text that you've downloaded from a website, or imported from another application. The TRIM function:

  • Removes spaces from start and end of text string
  • Removes all except single spaces between words
  • Does NOT remove some special space characters copied from websites

Refer Attached file.


Attached File : 25603 1068083 30fn30d trim function.xlsx downloaded: 379 times
Replies (3)

Very Good Move Sir......... It will be beneficial for all of us.Thanks for starting this series.Looking forward for 2nd part.....

a very good step sir..keep going...

Dear sir,

 

Excellent this is working 

Regards

Ramesha.m

 

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
26 September 2026
Chartared Accountant

pushpganga ventures

Pune

CA

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details