Pull street address out of cell

I have column B of address in the following format:

3636 Bravata Dr,  Huntington Beach, CA 92649

In column C,  I need to have just the street address, which is right before the first comma. Any ideas?
cansevinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pony10usConnect With a Mentor Commented:
In cell C1 put:

=LEFT(B1,FIND(",",B1)-1)
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.