I have a list of addresses. I want to separate the street number from the
street name. This is an obvious use of Date / Text to Columns.

My trouble is that I ONLY want to separate the number from the street name.
Instead, it separates EVERYTHING into separate columns. Like this:

12 Maple Street =
12 Maple Street
12595 S. 21st Avenue, 2nd Floor =
12595 S. 21st Avenue, 2nd Floor

Can anyone please advise me? Thanks!