Re: Removing full stops and extra spaces at the end of cells

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

From: Seraya (officelink_at_iinet.net.au)
Date: 03/11/04 

Date: 11 Mar 2004 15:52:41 -0800

JE McGimpsey <jemcgimpsey@mvps.org> wrote in message news:<jemcgimpsey-AE7100.13181510032004@msnews.microsoft.com>...
> In article <17e21c00.0403100304.7e6c1b30@posting.google.com>,
> officelink@iinet.net.au (Seraya) wrote:
>
> > JE McGimpsey, thanks for the macro code - I'm not too familiar with
> > macros but worked out how to instal it into a module and then ran it
> > and it was fantastic - cleared it all up in one fell swoop!
> >
> > I wondered if there was another macro that would replace all my
> > underscores with hypens. There are about 1000 of them so I'm really
> > trying to avoid having to replace each of them manually. If there is a
> > macro to fix this problem, I 'd so much appreciate it.
>
> If you want to change *all* underscores to hyphens, just use
> Edit/Replace (click the Replace All button).
>
> If you want to change only some of them, post back with the criteria for
> deciding which ones should be converted.

JE McGimpsey,

I tried to use edit/replace because I do need to replace every
instance of an underscore with a hyphen, however when I ask it to find
an underscore it says that there are none in the file, when in fact,
it's riddled with them. I then manually typed in some underscores and
did another find search, and it found these ones.

I'm thinking that maybe the underscores that are in the file are some
sort of special characters and not really underscores, since these
were the ones that originally turned into underscores from hyphens
when I copied and pasted from Word. I tried to copy and paste from
Excel back to word and found that the underscores now turned back into
hypens.

I'm not sure what's happening here - can you give me any suggestions
as to what I should do?

Thank you again for your help.

Seraya

Relevant Pages

  • Re: Removing full stops and extra spaces at the end of cells
    ... >> macros but worked out how to instal it into a module and then ran it ... I tried to use edit/replace because I do need to replace every ... I'm thinking that maybe the underscores that are in the file are some ... were the ones that originally turned into underscores from hyphens ...
    (microsoft.public.mac.office.excel)
  • Re: Function invocation location
    ... You use macros to do what? ... Avoid identifiers with leading underscores. ... The most likely reason you'd want this information is for debugging. ... a good source-level debugger should give you that ...
    (comp.lang.c)
  • Re: [PATCH V8 12/13] ptp: Added a clock driver for the IXP46x.
    ... Richard Cochran writes: ... I have had the experience back in 2.4 days of having my drivers ... Well, these two underscores mainly mean it's arch-dependent, but so are ... Actually, I was thinking about changing the macros some time ago, and it ...
    (Linux-Kernel)
  • Re: Return value for error
    ... with an E followed by a digit or uppercase letter and which then contain ... underscores... ... They may have OTHER macros that do, ... it's non-conforming. ...
    (comp.lang.c)
  • Re: macro conventions
    ... avoid collisions, best practice is simply never create a macro with an ... it's leading underscores that should be avoided. ... Luckily most collisions are grievous enough to become quickly ... all macros would be defined as ... ...
    (comp.lang.c)