I am doing a performance test where I neede to submit house name and postcode. I received the Address list from the developers and needed to seperate the house number from the first line from the address e.g. to get 10 from 10 Railway Cuttings.
This was done with a little bit of excel
=TRIM(LEFT(A1,FIND(" ",CONCATENATE(A1," "))));
where the first line of the address is in the A column.