ExcelBanter - trying to add text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - trying to add text (https://www.excelbanter.com/excel-worksheet-functions/42213-trying-add-text.html)

trying to add text

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?

Uncle O

You may use formula like this:

= &"Text" & (formula)

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

"MM" 來函：

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?

All times are GMT +1. The time now is 09:52 AM.