ExcelBanter - sum cells containing text

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

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

- - sum cells containing text (https://www.excelbanter.com/excel-worksheet-functions/255637-re-sum-cells-containing-text.html)

edul

sum cells containing text

Hi. Can anyone help me please.

I want to sum the values of certain cells, that contain numbers and text

eg. cell B2 contains 32A
cell B3 contains 12B
cell B4 contains 6C

the text will always be a, b or c, and always stay on the right

Thanks in advance

All times are GMT +1. The time now is 07:33 PM.