the result must be 'B'

other examples:

alphastreet 33
result - 33
block 33B
result -33B
new street 22 C
result -C

In fact i have to have the number of the address, if i can extract the
last space then i could go looking for the last numeric value in the
string. All chars after the numeric value are also part of the
number.
The final result must be:

alphastreet 33
result - 33
block 33B
result -33B
new street 22 C
result -22 C

If i get the solution for the first problem then it should be no
problem for me to get the final solution.


--
schuurke28
------------------------------------------------------------------------
schuurke28's Profile: http://www.excelforum.com/member.php...o&userid=15818
View this thread: http://www.excelforum.com/showthread...hreadid=273124