### VBA

Create a function using this code:

```
Function GETFORMULA(c As Range) As String
If c.HasArray Then
GETFORMULA = "{" & c.Formula & "}"
ElseIf VarType(c) = vbString And Not c.HasFormula Then
GETFORMULA = c.Value
Else
GETFORMULA = c.Formula
End If
End Function
```

The ff. formula will display the number of occurences of "+" in it.

```
=LEN(GETFORMULA(cell))-LEN(SUBSTITUTE(GETFORMULA(cell),"+",""))
```

### Non-VBA

Highlight the cells that contain formulas. If you only need to deal with one cell, just add a `'`

before the `=`

and skip the next step.

Press `Ctrl` + `H`. Enter `=`

into the **Find what** and `'=`

into **Replace With**. This will convert the formula to text.

Use this formula in a blank cell to count the number of occurences of "+".

```
=LEN(cell)-LEN(SUBSTITUTE(cell,"+",""))
```

To revert the cells back to the way they were, highlight them, press `Ctrl` + `H` and replace `'=`

with `=`

. Doing so will cause the formula above to show 0.