trying to add text

[Guest]

I have a spreadsheet with text on each cell and I would like to count each
cell with a number at the end. Any suggestions
Example Total on
Total off Total OT
name(A1) on(b1)on(C1)off(D1)OT(E1)
How woul i be able to do it?

 

[Guest]

You may use formula like this:

= &"Text" & (formula)

eg.
=& "No. of occurence of Cats:" & (countif($a:$a,"cat"))

"MM" 來函：