sorry for the dupe. this is too urgent.

http://www.excelforum.com/showthread...667#post925667

apprarently, my excel translate the "?" as any value.

therefore, i have fields such as "fhbdt460?846a7f78" where i need to just delete the "?".

any codes/help to make the function pick up the "?" as a value and not as any string.

thanks!

u can email me at ike301@gmail.com.

i have over 60K of lines to manually go thru! OUCH!