replace *

i was wondering if there's a way to replace the astris character ( * ) in the
built in find/replace tool in excel. anyone know how? for some reason excel
replaces every full cell instead of just the *'s. thanks

You're very welcome.........and thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3

"J" wrote:

> PERFECT! thank you so much! you saved me many hours of tedium
>
>
> "CLR" wrote:
>
> > Use the tilde character (~) before the star in the Edit > Replace
> > procedure..........
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "J" wrote:
> >
> > > i was wondering if there's a way to replace the astris character ( * ) in the
> > > built in find/replace tool in excel. anyone know how? for some reason excel
> > > replaces every full cell instead of just the *'s. thanks

Use the tilde character (~) before the star in the Edit > Replace
procedure..........

Vaya con Dios,
Chuck, CABGx3



"J" wrote:

> i was wondering if there's a way to replace the astris character ( * ) in the
> built in find/replace tool in excel. anyone know how? for some reason excel
> replaces every full cell instead of just the *'s. thanks