Hello,

I'm trying to isolate the street number from the street name. Text to columns splits in incorrect spots, as the data is not in a consistent format, some addresses contain 1/2 or a directional variable, N, S, E, W. Does anyone know how I can do this? Here is a same of the data:

1816 Bellevue Ave
2017 Bellevue Ave
2017-2019 3/4 Bellevue Ave
2711 Bellevue Ave
3000-3004 Bellevue Ave
3001-3007 Bellevue Ave
3408 Bellevue Ave
3517 Bellevue Ave
3601-3603 Bellevue Ave
3617-3619 1/2 Bellevue Ave
203-211 N Benton Way
336 N Benton Way
428 N Benton Way
635-637 N Benton Way
2527-2529 Berkeley Ave
615-619 1/2 N Bonnie Brae St
573 Boylston St

Thanks for the help.