Remember Me?

#1
October 28th 04, 12:29 PM
 schuurke28 Posts: n/a
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

#2
October 28th 04, 03:05 PM
 Frank Kabel Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM Adam Excel Discussion (Misc queries) 1 December 23rd 04 03:48 PM RPS Excel Discussion (Misc queries) 1 December 8th 04 03:36 AM PE Excel Discussion (Misc queries) 2 December 7th 04 02:00 AM schuurke28 Excel Worksheet Functions 1 October 28th 04 11:25 AM

All times are GMT +1. The time now is 03:41 PM.