extract text out of a string [SOLVED]

[hung2502]

	A	B
1
2	125 BUSINESS CENTER DR	125
3	127 BUSINESS CENTER DR	127
4	132 BUSINESS CENTER DR	132
5	143 BUSINESS CENTER DR	143

for the above table, I used the below code to extract numerical values in strings in column A and put the result in column B,
"=LOOKUP(99^99,--(0&MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890)),ROW(INDIRECT("1:"&LEN(A2)+1)))))"

Could you help me edit this code so that now the remainning texts will result in column C
(i.e. C2 will be "BUSINESS CENTER DR")

Thank you