PERFECT! thank you so much! you saved me many hours of tedium
J J Feb 13, 2006 #2 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
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
C CLR Feb 13, 2006 #3 You're very welcome.........and thanks for the feedback. Vaya con Dios, Chuck, CABGx3
C CLR Feb 13, 2006 #4 Use the tilde character (~) before the star in the Edit > Replace procedure.......... Vaya con Dios, Chuck, CABGx3
Use the tilde character (~) before the star in the Edit > Replace procedure.......... Vaya con Dios, Chuck, CABGx3
