ExcelBanter - cells containing text and numbers

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - cells containing text and numbers (https://www.excelbanter.com/excel-discussion-misc-queries/195623-re-cells-containing-text-numbers.html)

Jarek Kujawa[_2_]

cells containing text and numbers

if it's always 2 last digits use:
=RIGHT(A1,2)*1

"Am I right in suspecting that in cells containing a mix of letters
and
numbers, Excel does not treat the number as a number but rather as
general
text?"
yes, you are

All times are GMT +1. The time now is 02:16 PM.