[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

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?
0
cansevin
Asked:
cansevin
1 Solution
 
pony10usCommented:
In cell C1 put:

=LEFT(B1,FIND(",",B1)-1)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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