Array Formula and Substitute

[Jewells0905]

I am trying to write a formula to copy the contents of column C to column D, with the substitution of "Herbs and Spices" to "Herbs and spices".
This is what I currently have and am getting an error - Result was not automatically expanded, please insert more rows (1). (this is also with google sheets if that matters) =ARRAYFORMULA(SUBSTITUTE(C:C,"Herbs and Spices","Herbs and spices",C2:C908)) the arrayformula works on it's own.
This is just a small portion from the entire sheet, as I am not able to get the minisheet to upload

Food Name	Scientific Name	Group	Group (Cleaned)	Subgroup
Angelica	Angelica keiskei	Herbs and Spices	#REF!	Herbs
Savoy cabbage	Brassica oleracea var. sabauda	Vegetables		Cabbages
Silver linden	Tilia argentea	Herbs and Spices		Herbs
Kiwi	Actinidia chinensis	Fruits		Tropical fruits

 

[Jewells0905]

I am trying to write a formula to copy the contents of column C to column D, with the substitution of "Herbs and Spices" to "Herbs and spices".
This is what I currently have and am getting an error - Result was not automatically expanded, please insert more rows (1). (this is also with google sheets if that matters) =ARRAYFORMULA(SUBSTITUTE(C:C,"Herbs and Spices","Herbs and spices",C2:C908)) the arrayformula works on it's own.
This is just a small portion from the entire sheet, as I am not able to get the minisheet to upload

Food Name	Scientific Name	Group	Group (Cleaned)	Subgroup
Angelica	Angelica keiskei	Herbs and Spices	#REF!	Herbs
Savoy cabbage	Brassica oleracea var. sabauda	Vegetables		Cabbages
Silver linden	Tilia argentea	Herbs and Spices		Herbs
Kiwi	Actinidia chinensis	Fruits		Tropical fruits

nevermind I finally figured this one out. I used this formula =ARRAYFORMULA(SUBSTITUTE(C2:C, "Herbs and Spices", "Herbs and spices"))