is there a instrRev function in excel functions?

  • Thread starter Thread starter schuurke28
  • Start date Start date
S

schuurke28

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 th
last space then i could go looking for the last numeric value in th
string. All chars after the numeric value are also part of th
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 n
problem for me to get the final solution
 
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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
is there a instrRev function in excel functions? 1
Need help with range value calculation 5
countif with variabel criteria? 2
Figuring out a lengthy formula. Probably quite simple... 3
Excel VBA 1
How to turn a number range into a date 2
Calculations using Times in Excel 2003 6

Back
Top