+ Reply to Thread
Results 1 to 11 of 11

Removing Tab Spaces

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    365
    Posts
    4

    Removing Tab Spaces

    Apologies if this been answered before, but I'm having issues removing multiple tab spaces from cells. Tried using Find & Replace with alt + 0009, as well as ^t, but this does not appear to be searchable criteria in the current version of Excel. Any recommendations would be greatly appreciated.

    Thank you

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,043

    Re: Removing Tab Spaces

    Hello and welcome to the forum.

    I recommend uploading a small representative sample of your data that shows the spaces that you are talking about.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    365
    Posts
    4

    Re: Removing Tab Spaces

    Thanks, appreciate the tip. Attached are a couple of cells, and I'd like to remove the excess tabs to left align the text.
    Attached Files Attached Files

  4. #4
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    2,698

    Re: Removing Tab Spaces

    Try to Replace code 10 by code 32


    =SUBSTITUTE(A1,CHAR(10),CHAR(32))
    Last edited by Josť Augusto; 01-11-2019 at 01:08 PM.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    13,607

    Re: Removing Tab Spaces

    Select the range then Ctrl + H (Replace dialog box)

    Enter Alt + 0010 in What and a space in Replace.

    Note: 0010 MUST be entered from a number pad, not the numbers on the top of the keyboard.

  6. #6
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,828

    Re: Removing Tab Spaces

    I use the find / replace,
    click in find and hit ctrl and enter
    go to replace and hit the space bar
    then replace or replace all.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

  7. #7
    Registered User
    Join Date
    01-11-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    365
    Posts
    4

    Re: Removing Tab Spaces

    Thanks All, I appreciate the quick responses. These options worked for removing line-breaking spaces, but didn't appear to delete the tabbed spaces.

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,043

    Re: Removing Tab Spaces

    Tab is CHAR(9).

    Here's one option to get rid of them:

    B1 =SUBSTITUTE(A1,CHAR(9),"")

  9. #9
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,708

    Re: Removing Tab Spaces

    Another formula option.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    will remove CHARs 9, 10 & 13 (but not 160).
    Dave

  10. #10
    Registered User
    Join Date
    01-11-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    365
    Posts
    4

    Re: Removing Tab Spaces

    Thank you both - Falcondude, this is exactly what I needed. Very much appreciated.

  11. #11
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,043

    Re: Removing Tab Spaces

    You’re welcome, happy to help. Thanks for the rep!

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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