Results 1 to 3 of 3

Thread: How to get rid of empty space at start of Excel Cell

  1. #1
    Join Date
    Nov 2011
    Posts
    166

    How to get rid of empty space at start of Excel Cell

    I am copying text (data) from Word to Excel 2003 and it's bringing in a space in the beginning of the cell, such as "_John Smith". What's the quickest and/or easiest way I can delete this. Obviously, I don't want to get rid of the space in between words, just in the beginning of the cell.

  2. #2
    Join Date
    Jul 2011
    Posts
    640

    Re: How to get rid of empty space at start of Excel Cell

    You can apply a formula in a helper column and then copy it down. If your data is in A1, then you will need this formula: =RIGHT(A1,LEN(A1)-1) or this one: =TRIM(A1). The second one will only remove normal spaces that have the ASCII code of 32, whereas the first one will remove the first character even if it is the non-breaking space (code 160).

  3. #3
    Join Date
    Jul 2011
    Posts
    634

    Re: How to get rid of empty space at start of Excel Cell

    Click the below link for detailed information on the process to get rid of extra spaces at the beginning of cell in Excel. There ample of samples available on the site below which offers you detailed approach on the issue.

    Remove spaces from the beginning and end of a cell

Similar Threads

  1. How to disable excel for taking empty cell in Excel chart
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 12:30 PM
  2. Replies: 4
    Last Post: 25-01-2012, 12:05 PM
  3. Replies: 2
    Last Post: 04-01-2012, 06:54 PM
  4. How to find string that doesn't start with empty space?
    By MACE in forum Software Development
    Replies: 4
    Last Post: 02-03-2010, 06:21 PM
  5. How to copy data into next empty cell in new sheet
    By Saaarc in forum Software Development
    Replies: 3
    Last Post: 20-10-2009, 12:21 PM

Tags for this Thread

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
  •  
Page generated in 1,711,640,823.32356 seconds with 17 queries