SOLVED

# Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,",","!",2))-1)

Copper Contributor

# 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 of everything after the second comma in a cell.

Thanks!

5 Replies

# Re: Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,&quot

Which value in the formula should be changed?

best response confirmed by PopTart031790 (Copper Contributor)
Solution

# Re: Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,&quot

You can check if calculation options are set as manual with this path:

Formulas -> Caluculation options -> Manual

If so, change Manual to Automatic.

# Re: Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,&quot

Check that Calculation Options in the Calculation group of the Formulas tab of the ribbon is set to Automatic.

# Re: Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,&

That was it! Manual instead of Automatic. Thanks so much for the quick response!

# Re: Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,&

You were exactly right - it was set to manual instead of automatic. Thanks for the quick response!
1 best response

Accepted Solutions
best response confirmed by PopTart031790 (Copper Contributor)
Solution

# Re: Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,&quot

You can check if calculation options are set as manual with this path:

Formulas -> Caluculation options -> Manual

If so, change Manual to Automatic.