Solved

Pull City out of excel

Posted on 2013-11-25
2
254 Views
Last Modified: 2013-11-25
I have a column of addresses that are all in this form:

"11493 East Rosehedge Dr
Whittier, CA 90606"

After the "Enter" and before the first Comma is the City. I want to pull just the city out of the cell in the next column. Any idea? First on is in Cell C2.
0
Comment
Question by:cansevin
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
Comment Utility
Try this formula in D2 copied down

=REPLACE(LEFT(C2,FIND(",",C2)-1),1,FIND(CHAR(10),C2),"")

regards, barry
0
 

Author Closing Comment

by:cansevin
Comment Utility
Worked great, thansk!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now