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