if the street number is always first
try
=left(a1,find(" ",a1))
and
=right(a1,len(a1)-find(" ",a1))


"ClaireView" wrote:

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!