Pull street out of address

I have an address in the form of:

8065 Elk Grove Florin Road, Sacramento, CA 95829

I want to pull just the street number and name out. Basically everything to the left of the first comma. How can I pull this out?
cansevinAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
=TRIM(LEFT(A1,FIND(",", A1)-1))
0
 
Katie PierceCommented:
Or, highlight the cell, go to the Data ribbon, click Text to Columns, select delimited, then use the comma as the separator. This will split the info into one cell for each item between commas.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.