Hello guys,

I've tried to search answer for this tough nut for quite some time already, without a success.


What should be the formula on Column B in the following case:

A1 value = "22-25-29---/29-----"
B1 should return 29

A2 value = "45-109----/28-45-108---"
B1 should return 45

A3 value = "33-46-24-56-/12-23-56-60-"
B3 should return 56
and so on....

I bet this should be done with some kind of array formula or alternatively with VBA.

Thanks in advance for anyone who could help.