Re: Tab character is messing me up

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It's not carriage return. Know were I might find a table of all the other
symbols?

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:hk53a219l9g1aavcqlg2afq87fkapdh3uh@xxxxxxxxxx
The little boxes could be carriage returns.

To get rid of then do an Edit>Replace

What: ALT + 0100(from the numpad, not the regular keys)

With: space or nothing

Replace all.

If your boss set his cells to "wrap text" he would not see the little
boxes.

If you want to see them, uncheck "wrap text"


Gord Dibben MS Excel MVP


On Tue, 27 Jun 2006 14:42:52 -0500, "Some Dude" <sdatt@xxxxxxxxxxx> wrote:

I imported some data from one an excel file on one of our company web
sites.
When I look at it everything looks fine. When my boss looks at it he sees
characters shaped like little boxes where I see blank spaces. I copied the
blank spaces and pasted them into Word and I can see the arrows you'd see
for tabs in a Word document if you selected View Paragraph marks.
How can I replace these with blank space in the Excel file?
Why can my boss see them in excel but I can't?




.

Relevant Pages

  • Re: Tab character is messing me up
    ... If your boss set his cells to "wrap text" he would not see the little boxes. ... for tabs in a Word document if you selected View Paragraph marks. ... How can I replace these with blank space in the Excel file? ...
    (microsoft.public.excel.misc)
  • Re: Re: Updating Excel Links
    ... My Word document consists of almost nothing more than a couple hundred Excel ... WHAT I'D LIKE -- the user stores both files in the same folder. ... Jean-Guy Marcil - Word MVP ...
    (microsoft.public.word.vba.general)
  • Re: Admins to Boxes ratio
    ... boss, it's CRITICAL that you make these ideas your boss's ideas. ... critical step if you're the only S/A managing these boxes. ... high risk environment. ...
    (AIX-L)
  • Re: Linking Excel Objects to Word in Office 2007
    ... I find that links to Excel update automatically in both Word ... IN other words, Word appears to be doing the obvious thing of realising that the Excel workbook path is no longer valid, checking that the Excel workbook is now in the same folder as the Word document, and modifying the link. ...
    (microsoft.public.word.docmanagement)
  • Re: Help creating database
    ... After the first round, the client can walk away with what they have so far, ... help you shoot yourself and your boss in the foot or feet. ... The problem with so many amateur Excel ... For a journeyman Access developer your proposed application seems to ...
    (microsoft.public.access.gettingstarted)