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 ...
Formulas and Functions
  • 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.

HansVogelaar's avatar
HansVogelaar
MVP

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.

anupambit1797's avatar
anupambit1797
Iron Contributor
Mar 10, 2023

HansVogelaar, Thanks Hans, I attach a sheet "Test.xlsx" could you please share on how to do this.

 

Many Thanks ,

Br,

Anupam

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    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's avatar
      anupambit1797
      Iron Contributor
      Mar 10, 2023
      Thanks a lot Hans, may I also ask for one alternate solution as well, just in case if any possibility..

      Thanks ,
      Br,
      Anupam

Share

Resources