Forum Discussion
Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,",","!",2))-1)
Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,",","!",2))-1) I have checked the copy down tab is on. No locked values in my formula. Simply trying to get rid ...
You can check if calculation options are set as manual with this path:
Formulas -> Caluculation options -> Manual
If so, change Manual to Automatic.
