Forum Discussion
Solved
Excel fills unselected cells, and the formula is duplicating without a reason
I'm trying to fill the cells with the right text but i'm facing this issue. can anybody help me with this, plesse?
You have two options.
Option 1:
- Select cell T3.
- Enter the formula =IF(ISNUMBER(SEARCH(C3,"...")),"O.Two.O","")
- Replace ... with the Arabic (?) text.
- Fill down.
Or:
Option 2:
- Select T3:T13612, as in the video.
- Enter the formula =IF(ISNUMBER(SEARCH(C3:C13612,"...")),"O.Two.O","")
- Replace ... with the Arabic (?) text.
- Confirm the formula by pressing Tab or Enter, not by pressing Ctrl+Enter.
Since C3:C13 is a range of 13 cells, SEARCH("...",C13) also returns a range of 13 cells in Excel in Microsoft 365 and Office 2021.
What exactly do you want to accomplish?
You have two options.
Option 1:
- Select cell T3.
- Enter the formula =IF(ISNUMBER(SEARCH(C3,"...")),"O.Two.O","")
- Replace ... with the Arabic (?) text.
- Fill down.
Or:
Option 2:
- Select T3:T13612, as in the video.
- Enter the formula =IF(ISNUMBER(SEARCH(C3:C13612,"...")),"O.Two.O","")
- Replace ... with the Arabic (?) text.
- Confirm the formula by pressing Tab or Enter, not by pressing Ctrl+Enter.
HansVogelaar if Excel found the "a word" within C3:C13 write the word O.Two.O in the selected cells in T column.
