Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Mar 10, 2023

Replace function

Dear Experts,

                   I have a situation , where I want to replace the integers within the red-box with a Text = Even/Odd, so 0 shall be replaced by Even, 1 shall be replaced by Odd, any quick method to achieve this?

 

 

Thanks & Regards

Anupam Shrivastava

 

  • HansVogelaar's avatar
    HansVogelaar
    Mar 10, 2023

    anupambit1797 

    In A5, enter the formula =IF(ISODD(A1),"Odd","Even")

    Fill to the right to L5, then fill down to row 7.

    With A5:L7 still selected, copy the range (click Copy on the Home tab of the ribbon or press Ctrl+C).

    Select A1, then click the lower half of the Paste button on the Home tab of the ribbon and select Values.

    You can now clear A5:L7.

  • anupambit1797 

    You could use formulas in a different range of the form

     

    =IF(ISODD(cell, "Odd", "Even"))

     

    Then copy the range with the formulas and paste it as values over the range in the red box.

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        anupambit1797 

        In A5, enter the formula =IF(ISODD(A1),"Odd","Even")

        Fill to the right to L5, then fill down to row 7.

        With A5:L7 still selected, copy the range (click Copy on the Home tab of the ribbon or press Ctrl+C).

        Select A1, then click the lower half of the Paste button on the Home tab of the ribbon and select Values.

        You can now clear A5:L7.

Resources