ExcelBanter - replace *

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