Removing Non-Breaking Spaces from Excel Cells: A Quick Guide

Many times there comes a scenario where we need to remove extra space from text in cell which has numbers in it, the Trim() function only doesn't work, we may need to use TRIM function combined with any other function (or) need to use VALUE function combined with any other function.

Excel's TRIM() function is a lifesaver when it comes to removing leading and trailing spaces from text. However, it can be less effective when dealing with non-breaking spaces, which are often used to prevent text from breaking to the next line.

The extra space is not a space it is a non-breaking space recognized as CHAR(160), to remove this non-breaking space need to use the below formula,

VALUE(SUBSTITUTE(A2, CHAR(160),))

Example:

If cell A2 contains the text "225422  " (with a non-breaking space after the number), applying the formula would result in "225422" with no extra spaces.

By following these steps, you can effectively remove non-breaking spaces from your Excel data and ensure accurate calculations and formatting.

Tags :
I write things which I face in day to day life of online and have difficulty implementing it, includes topics about Android, Ubuntu, Windows 10, Android apps making using Android studio, Google tips and tricks, blogging SEO tips and much more. I will also share about cinema activity and fun things around the world. Follow me on Twitter➤ twitter.com/legaluser Facebook➤facebook.com/syedahmed085

Comments

Post a Comment

Please share your opinions and suggestion and do not enter any spam links in the comment box

Popular posts from this blog

How To Record Audio in Moto G Without Any Third Party Apps

Image
Although there is no in-built app (or) interface in the Moto G to record audio, however, there is a workaround from which you can record audio and save it. To do that just go to the Messaging app >>> New Message >>> Click on Attach >>> Record Audio Below is screenshots illustrating : Also Read:  How I Submitted My Blog to Google Search Now all you have to do is record your audio, play it and then remove it, Now you can find the audio automatically get saved in the memory, which you can access through any File Manager  (or) you can play it again in Google Play Music . Below are all my recordings saved in memory, which I have accessed through ES File Explorer (File Manager) So Enjoy all the fun stuff in the Moto G , if you have a better suggestion please voice your opinion in the comments section. Also Read:  How I loaded my website quick and fast
KNOW more »

How to Unistall Software (or) Programs in Ubuntu Using the Terminal

If you want to uninstall the installed programs using Terminal follow these steps Open the terminal using ctrl + alt + t Browse your installed programs by entering the command dpkg --list and note down the name of package you desired to uninstall                                 (or)           dpkg --list to check if the package has the same as the program name        3. a) Uninstall the package (or) program only use the command sudo apt-get remove              Eg: sudo apt-get remove yelp                          b)To uninstall the program along with its configuration files use the command sudo apt-get --purge remove             Eg: sudo apt-get --purge remove yelp
KNOW more »

All the Questions Answered About Rs.500 and Rs.1000 In this Frequently Asked Question Document

1. Why is this scheme? The incidence of fake Indian currency notes in higher denomination has increased. For ordinary persons, the fake notes look similar to genuine notes, even though no security feature has been copied. The fake notes are used for anti-national and illegal activities. High denomination notes have been misused by terrorists and for hoarding black money. India remains a cash-based economy hence the circulation of Fake Indian Currency Notes continues to be a menace. In order to contain the rising incidence of fake notes and black money, the scheme to withdraw has been introduced. 2. What is this scheme? The legal tender character of the notes in denominations of ₹ 500 and ₹ 1000 stands withdrawn. In consequence there,of withdrawn old high denomination (OHD) notes cannot be used for transacting business and/or store of value for future usage. The OHD notes can be exchanged for value at any of the 19 offices of the Reserve Bank of India or at any of the bank branches
KNOW more »