Friday, 19 June 2015
How to remove white spaces in spreadsheet
There is no in built function in excel for removing whites spaces when it appears at the end of a text or middle of a text , but you may wonder why can't we use the Trim Function. Yes, Trim () Function works when there is a white space at the beginning of a text area. But It doesn't work with with all instances.
I have also tried filtering white spaces and do a "Find and Replace" But It replaces all white spaces within a cell , what I actually mean is when there is a single space between 2 words. This removes all the white spaces.
I finally found google sheet is a good solution to solve this problem in no time. What you have to do is
I have also tried filtering white spaces and do a "Find and Replace" But It replaces all white spaces within a cell , what I actually mean is when there is a single space between 2 words. This removes all the white spaces.
I finally found google sheet is a good solution to solve this problem in no time. What you have to do is
- Sign into your Google account.
- Create a blank spreadsheet.
- Now go and copy the data areas in your excel.
- Now Paste the copied data into newly created google sheet.
- All the white spaces will have been removed.
- Now copy the data from google sheet into your excel.
That's it you are done. It saves lot of your time. I have found there are some Excel Add-on such a kutools for excel would also do this. But you may need to pay for it when the trail period ends.
Subscribe to:
Post Comments
(
Atom
)
statistics
Powered by Blogger.
Categories
Recent
Subscribe
Search This Blog
Pages
Blog Archive
Contact Me
Popular Posts
-
This Acrobat Error happens often with My Acrobat Pro. I was searching online for a solution none of the articles gave me a solution finally...
© Knowledge Meeting 2013 . Powered by Bootstrap , Blogger templates and RWD Testing Tool
No comments :
Post a Comment