is there a instrRev function in excel functions?
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 |
All times are GMT +1. The time now is 03:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com