">
TechMoran
  • About Us
  • Deals
  • Jobs
  • Motoring
    • Money
  • Pitch Your Startup
  • Submit Your Post
  • Freelance Gigs
  • Travel
  • Men’s Corner
  • Dating
Saturday, February 27, 2021
  • Startups
  • Reviews
  • Insider
    • Obituaries
  • Business
  • Women
  • Blockchain
  • Columnists
  • Hacks & Facts
    • How To
  • Editions
    • US Edition
    • India Edition
    • MENA Edition
    • Asia Edition
    • Europe Edition
    • International Edition
No Result
View All Result
TechMoran
">
Home How To

How to use the TRIM function in Microsoft Excel

Yvone Kendi by Yvone Kendi
4 days ago
in How To
4 min read
0

The Microsoft Excel TRIM function returns a text value with the lead and trailing spaces removed. You can also use the TRIM function to remove unnecessary space between words in a string. TRIM allows users to quickly remove unnecessary spaces from large data sets, saving you time in the process.

Steps to use the Excel Trim function

Replace the “A2” cell reference with your own.

To eliminate excess spaces from a text string directly, you can use the following formula to replace the example string with your own text.

=TRIM (” This text string contains unnecessary spaces”)

TRIM is intended to remove extra ASCII space characters (decimal value 32) from text strings.

NB: If you really see unnecessary spaces, this is probably caused by a non-breaking space character (Unicode Decimal Value 160) in your text.

Related posts

How to Choose a Forex Broker?

February 25, 2021
0

How to send and receive text messages to your PC without a cell phone

February 24, 2021
0

How to view and manage your Android phone notification using Windows 10 Your Phone app

February 24, 2021
0

How to Schedule Texts on Android

February 24, 2021
0

TRIM does not support these, so you will need to manually check and remove these characters from your text if you prefer to use them.

Readers 489

Share

  • Click to share on Telegram (Opens in new window)
  • More
  • Click to share on Tumblr (Opens in new window)
  • Click to print (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Pocket (Opens in new window)

Like this:

Like Loading...

Related

Tags: Trim function
Yvone Kendi

Yvone Kendi

Writer. Lover of life. Helping you with simple life hacks using technology.

Related Posts

Columnists

How to Choose a Forex Broker?

February 25, 2021
0
How To

How to send and receive text messages to your PC without a cell phone

February 24, 2021
0
How To

How to view and manage your Android phone notification using Windows 10 Your Phone app

February 24, 2021
0
Android

How to Schedule Texts on Android

February 24, 2021
0
Hacks & Facts

Understanding how VPN apps work 101

February 24, 2021
0
How To

How to make a “go home” shortcut on the iPhone

February 24, 2021
0
How To

How to set up Siri on your iPhone or iPad

February 24, 2021
0
How To

How to purchase Airtel Airtime via MPESA

February 23, 2021
0

ADVERTISEMENT

Join our Mailing List

Loading

Recent Posts

Twitter To Start “Super Follow” Tweets You Have to Pay For

February 27, 2021

How To Add Group iMessages

February 27, 2021

Twitter Is Working on a New Anti-Troll Feature

February 27, 2021
group of african american college students closeup

8 tips that students can use to ‘learn better’

February 27, 2021

5 Totally Thoughtful Gifts That’ll Light Up Someone’s Life

February 27, 2021
">
">

Follow Us

">

There are many sites out there focused on blowing off some steam, from funny entertainment to thrilling experiences like playing online, in some cases online gaming could grant you the chance to win extra money. We came across rocketpot.io while browsing for a good btc casino online and it left us a very good impression with their wide variety of games and crypto offering.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

© 2019 Moran Media Group - All rights reserved TechMoran.

No Result
View All Result
  • Startups
  • Reviews
  • Insider
    • Obituaries
  • Business
  • Women
  • Blockchain
  • Columnists
  • Hacks & Facts
    • How To
  • Editions
    • US Edition
    • India Edition
    • MENA Edition
    • Asia Edition
    • Europe Edition
    • International Edition

© 2019 Moran Media Group - All rights reserved TechMoran.

Login to your account below

Forgotten Password? Sign Up

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.
%d bloggers like this: