Forum Discussion

Copper Contributor

Nov 15, 2022

Solved

How to count symbols in a cell in MS Excel

I have a cell reference which contains six codes: B_NEW_2; B_NEW_3; B_NEW_4; B_NEW_5; B_NEW_6; B_NEW_7 in MS Excel. I wish to calculate the number of semi colons in the cell. Please advise.

BI & Data Analysis

excel

Formulas and Functions

power bi

mtarler
Nov 15, 2022
a common technique for this is:
=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))

mtarler

Silver Contributor

Nov 15, 2022

a common technique for this is:
=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))

te7037

Copper Contributor

Nov 16, 2022

Thank you. It worked.