Originally Posted by mytyab

Does anyone know of a quick and easy way to remove text characters from within a number? My numbers look like 186R1114F0010, 186011T3F0233 and 18H01135F0557. I have about 3,000 cells to convert to an all numeric number per day. Currently I am using the find/replace function on every letter in the alphabet. This works well but is a little tedious.

thank you for any help you can give