Extract from the last number with an alphanumeric value.

[BrownBoy]

This might be more appropriate for a VBA thread, but I'd thought I start here. I need to extract all characters to the right of the last number of an alphanumeric value in a cell. This will exclude any spaces that may start at the beginning.

Here's an example:

The last number is "0" so....it would result in:

[JieJenn]

Pretty sure someone who is more experienced can come with formula solution. But for VBA, maybe created an UDF.

Please Login or Register  to view this content.

[samba_ravi]

=trim(mid(a1,lookup(2,1/isnumber(--mid(a1,row(1:256),1)),row(1:256))+1,256))
try this if you have data in cell a1

[mcmahobt]

This may work also, assuming no other "." exist in your data:

Please Login or Register  to view this content.

[BrownBoy]

nflsales,

That worked. Thanks. The UDF did not (thanks anyways) and mcmahobt, smart thinking using the decimal.