Forum Discussion
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 ...
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, Thanks Hans, I attach a sheet "Test.xlsx" could you please share on how to do this.
Many Thanks ,
Br,
Anupam
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.
- Thanks a lot Hans, may I also ask for one alternate solution as well, just in case if any possibility..
Thanks ,
Br,
AnupamWould a VBA macro be OK?
- Sorry , I am not much comfortable with VBA 😞
