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

replace *
 

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

replace *
 

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