Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

Pull Street Address out of cell

I have a data in a cell with the below format. How do I pull out just the street address? The part to the left of the comma:

674 N Las Posas Rd, Camarillo, CA 93010
0
cansevin
Asked:
cansevin
1 Solution
 
ProfessorJimJamCommented:
=LEFT(A1,(FIND(",",A1,1)-1))
0
 
aikimarkCommented:
In a formula, like this:
=LEFT(A1,FIND(",",A1,1)-1)

Open in new window

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now