If your formula currently uses ; like:=SUM(A1;B1;C1)Replace it with commas:=SUM(A1,B1,C1)You can do a quick Find/Replace (Ctrl+H) in the formula bar for ; → ,. Without the formula and the digital environment (operating system, Country, storage medium, etc.), unfortunately, we can only guess, and I'm not good at guessing. My answers are voluntary and without guarantee! Hope this will help you.

Forum Discussion

RawrZillaFace

Copper Contributor

Nov 01, 2025

Formula broke, need commas back. (complicated)

this is **bleep**

excel

Formulas and Functions

office 365

1 Reply

NikolinoDE
Platinum Contributor
Nov 04, 2025
If your formula currently uses ; like:
=SUM(A1;B1;C1)
Replace it with commas:
=SUM(A1,B1,C1)
You can do a quick Find/Replace (Ctrl+H) in the formula bar for ; → ,.

Without the formula and the digital environment (operating system, Country, storage medium, etc.), unfortunately, we can only guess, and I'm not good at guessing.

My answers are voluntary and without guarantee!

Hope this will help you.