G
Guest
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!
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!