Find position of last number in string

[MaartenRo]

Hi,

I would like a macro to find the postition of the last number in a string. E.g. for "hello2021today" it should give 9.
Any ideas?

[jindon]

Simple UDF.
Use in cell like
=FindLastDigit(A1)

Please Login or Register  to view this content.

[Rick Rothstein]

You say you want a macro, but it sounds more like you would want a UDF (user defined function), so that is what I am giving you (you can convert this easily enough into a macro if that is really what you want)...

Please Login or Register  to view this content.

[jindon]

E.g. for "hello2021today" it should give 9.

Post #2 or
=MAX(IF(ISNUMBER(MID(A1,ROW(1:500),1)+0),ROW(1:500)))
Confirm with Ctrl + Shift + Enter (array formula entry)