Knowledge Meeting

  • Getting started
  • CSS
  • Components
  • JavaScript
  • Customize
  • Dropdown
    • Action
    • Another action
    • Something else here
    • Separated link

Friday, 19 June 2015

How to remove white spaces in spreadsheet

Posted by Tips from Prince at 12:26 Labels: Excel
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


  1. Sign into your Google account. 
  2. Create a blank spreadsheet. 
  3. Now go and copy the data areas in your excel.
  4. Now Paste the copied data into newly created google sheet. 
  5. All the white spaces  will have been removed. 
  6. 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.
Tweet

Related Posts

  • Excel formula to Count Specific Words in a Cell
    Excel formula to Count Specific Words in a Cell

No comments :

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments ( Atom )

statistics

Sparkline 1,328 Total Post 15
Powered by Blogger.

Categories

  • Error Solutions
  • Excel

Recent

Subscribe

Search This Blog

Pages

  • Home

Blog Archive

  • 2015 (6)
    • December (1)
    • October (1)
    • June (4)
      • How to remove white spaces in spreadsheet
      • Excel formula to Count Specific Words in a Cell
      • How to Resize PDF Page Size
      • Which is best payment method for freelancers

Contact Me

Name

Email *

Message *

Popular Posts

  • How to Solve Adobe Acrobat "Out of Memory" Error
    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...
  • Which is best payment method for freelancers
    When it comes to get your money into your pocket it is vital important how are you going to withdraw. These questions may rise in your mind...
  • How to Resize PDF Page Size
    This article intend to show how to resize an already existed PDF's page size. Let say you have a PDF page which is in A2 size probabl...
  • Excel formula to Count Specific Words in a Cell
    This tutorials shows you how to count specific words in excel cell. As shown in the picture we are going to find the number occurr...
  • 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 ...
  • Google Sheet Conditional Formatting for Different Ranges
    I'm an Excel user for may years and I'm good at working with excel conditional formatting. However When my clients asked me to do a...

© Knowledge Meeting 2013 . Powered by Bootstrap , Blogger templates and RWD Testing Tool