Several ways to go about this.
Now do you simply want to strip out the numerical portion of the address and store it in a new attribute or do you simply want to get rid of it.?
I will assume you want to preserve the numerical portion of the address.
This part will allow you to populate the new Number attribute
left( [servAddr1], (instr(1, [servAddr1]," ")-1))
what this does is takes the left portion of the full address up to the first space and populate just that. The -1 is critical or it will copy the space as well.
for the rest of it this formula will take everything but the number. I populated servAddr2 with the number
mid( [servAddr1], (len( [servAddr2])+2),50)
In this case it will populate the street portion with everything after the space after the number. It will take the length of your address portion and start there and put in everything after that. The +2 is important so it will start 2 spaces after the end of the number and not include the space.
it actually takes a lot longer to write this than it does to do it. Just substitute servAddr1 with your attributes.