Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to remove the tab symbol (the square thing)...

  1. #1
    Board Regular
    Join Date
    Sep 2003
    Location
    Orange County
    Posts
    150
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to remove the tab symbol (the square thing)...

    I have just imported a big tab delimited text file into Excel but I see a big square symbol (it is the tab symbol) at the beginning of all of my cells. Is there a way to remove these without doing

    =right(b6)-1

    to all the cells?

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,457
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How to remove the tab symbol (the square thing)...

    How about Data-->Text to Columns?

  3. #3
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove the tab symbol (the square thing)...

    This:

    =CLEAN(B6)

    should do it.

    Or Data|TextToColumns|Delimited. At step 2 check Tab. At Step 3 click column 1 and check Do not import column (skip).

  4. #4
    Board Regular
    Join Date
    Sep 2003
    Location
    Orange County
    Posts
    150
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove the tab symbol (the square thing)...

    worked swimmingly, thanks!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com