On Wed, 10 Feb 2010 07:56:01 -0800, ????? (????) ????? <micky-a*at*tapuz.co.il
wrote:

Wouldn't this - in B1 - be simpler and shorter ?
=SUBSTITUTE(A1,C1," ")
Micky

Simpler, shorter, but not as robust.

In the OP's example, the address number is always at the end of the string.

Your solution fails if the address number happens to be included in the street
name.
--ron