=if(istext(A1),b1,A1) and fill down to the end of your range.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Diana" wrote:

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.