Micro or Function???
 

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.

Micro or Function???
 

=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.

Micro or Function???
 

Thank you so much! All I need to know is where to post the formula and I
tried to fill it down but I think i'm doing it wrong. One more hint please? :)

"Dave F" wrote:

=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.