Forum Discussion
Excel fills unselected cells, and the formula is duplicating without a reason
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.
Thank you so much for helping me I tried my first formula =IF(SEARCH("...",C3),"O.Two.O")
but only selected C3 cell not (C3:C13612) and the spill error was gone.My Excel is acting very strange because C3 doesn't even have the word in Arabic that is in the formula but Excel still managed to find the corresponding cells in T column and filled them down with O.Two.O.
I also I tried the formula =IF(SEARCH("او تو او",C3),"O.Two.O", "") but I got the Value error but it's easy to get rid of not like Spill errors.When I tried the formulas you provided me they didn't work for some reason.
HansVogelaar if Excel found the "a word" within C3:C13 write the word O.Two.O in the selected cells in T column.
