+ Reply to Thread
Results 1 to 7 of 7

How to remove blank space in cell

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    268

    How to remove blank space in cell

    Friends,

    PFA.

    I need to remove the blank space in cell. (col A)
    the Output required in given in col. B

    The data is huge and doing it manually is very time consuming.

    Can you please assist ?
    Attached Files Attached Files
    Last edited by lalaarif1; 03-29-2019 at 08:58 AM. Reason: massgae updated.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: How to remove blank space in cell

    You can use "Clean" function to remove spaces.

    Please refer the link for more info:https://www.ablebits.com/office-addi...-spaces-excel/
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: How to remove blank space in cell

    Try this in B2:

    =SUBSTITUTE(A2,CHAR(160),"")+0

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: How to remove blank space in cell

    There are not spaces, there are CHAR(160), so TRIM does not working.
    Use (into B2):

    Please Login or Register  to view this content.
    and drag it down as needed.

    I've put *1, because you want to sum it, so it have to be 'convert' to number.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  5. #5
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    268

    Re: How to remove blank space in cell

    Friends...

    Wow.... u made my day....
    Thanks a lot.
    Last edited by lalaarif1; 03-30-2019 at 12:35 AM.

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: How to remove blank space in cell

    You're welcome. Glad we could help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  7. #7
    Registered User
    Join Date
    09-21-2020
    Location
    Pakistan
    MS-Off Ver
    MS Office 2016
    Posts
    5

    Re: How to remove blank space in cell

    Thank you for helping me as well :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Remove blank space in front of text to turn into a number. Trim, Substitute will not work.
    By jaboomgaarden in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2018, 05:59 PM
  2. Remove from over 2 blank space to 1 space.
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-12-2018, 08:27 PM
  3. VBA to remove the blank space in the cell
    By saranyabi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2013, 10:10 AM
  4. remove space and blank
    By lassaad.toukabri in forum Excel General
    Replies: 5
    Last Post: 11-22-2013, 12:27 PM
  5. [SOLVED] If Cell Starts with a Space, remove that space
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 09-29-2012, 01:52 PM
  6. Remove Blank Space at end of the txt
    By tek9step in forum Excel General
    Replies: 6
    Last Post: 02-26-2010, 05:42 AM
  7. remove blank space in cell?
    By gunsmokegirl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2008, 02:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1