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