Link to home
Start Free TrialLog in
Avatar of cansevin
cansevin

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.