Results 1 to 4 of 4

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

This is a discussion on How to remove the tab symbol (the square thing)... within the Excel Questions forums, part of the Question Forums category; I have just imported a big tab delimited text file into Excel but I see a big square symbol (it ...

  1. #1
    Board Regular
    Join Date
    Sep 2003
    Location
    Orange County
    Posts
    150

    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
    Crested Butte, CO
    Posts
    26,861

    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
    64,589

    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

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

    worked swimmingly, thanks!

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