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

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=MID(A1,MIN(IF(ISNUMBER(-MID(A1,seq,1)),seq)),20)

where seq is a defined name with the referring formula:
seq: =ROW(INDIRECT("1:1024"))

"schuurke28" wrote:


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