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

Resources