Are all your text values laid out the same:

3 digits, 1 alpha, 1 digit, 1 alpha, 1 digit, 1 alpha?

If so, then use

=value(left("123a4b5c",3)&mid("123a4b5c" 5,1)&midmid("123a4b5c" 7,1))





"SakDaddy" wrote:

If I have a column of numbers that have 123a4b5c and I want to remove the
"abc" so that the change reads 12345, what is the function I use?