Re: Macro Help

Tech-Archive recommends: Fix windows errors by optimizing your registry

Maybe you don't need a macro:
select the range to fix
edit|Replace
what: (* (open paren, followed by an asterisk)
with: (leave blank)
replace all

You may want to replace " (*" -- spacebar, open paren, then asterisk.

"briandhowells@xxxxxxxxx" wrote:

Hi,

I'm looking for a macro that will take a column of data that look like
this

B. Tallackson (1)
I. Pikkarainen (1)
J. Pushor (1)
A. Murray (1)
B. Simon (33)
M. Hartigan (51)
G. Platt (1)
P. Vrana (31)

and delete the paranthases and any numbers in them.

Much appreciated.

Thanks!

--

Dave Peterson
.

Relevant Pages

  • Re: FUNCTIONS NOT FOUND
    ... Recalculation wasn't enough to fix the formula. ... I have one question on the Macro you supplied. ... Hit F2 and enter to recalculate that cell ...
    (microsoft.public.excel)
  • Re: [PATCH][TRIVIAL] Remove bogus "value 0x37ffffff truncated to 0x37ffffff" warning.
    ... >The problem is in the MAXMEM macro. ... This looks like a neat fix, faint praise from someone who doesn't know ... Copyright 2003 by Maurice Eugene Heskett, ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Comments
    ... I made a mistake in a different post and the same mistake here: ... Dave Peterson wrote: ... > You could even show all the rows in the macro, but then you might be screwing up ... Any fix for that? ...
    (microsoft.public.excel.misc)
  • Nasm 2.05rc1 released
    ... Fix redundant REX.W prefix on `JMP reg64'. ... `%error' directives are now deferred to the final assembly ... New `%use' macro directive to support standard macro directives. ... Add AVX versions of the AES instructions. ...
    (comp.lang.asm.x86)
  • Nasm 2.05rc1 released
    ... Fix redundant REX.W prefix on `JMP reg64'. ... `%error' directives are now deferred to the final assembly ... New `%use' macro directive to support standard macro directives. ... Add AVX versions of the AES instructions. ...
    (alt.lang.asm)