ir 660
250
350
700
ar 987
320
710

I am trying to create a macro or find a formula that would replace the text
values in the first columns with the numerical values to their right.

Please help.

Thank you,
Diana.