Home » Forums » Open Source Learning Center » Question and Answer

extract fields

Submitted by babijaen on 16 February, 2015 - 07:59

Hi please help me to extract city from address when no seperators where used
Eg:address is -'800 Town And Country Blvd Houston, TX'.i have to extract city from this.please help me to do this

‹ copy output of cell with formula to another worksheet without blank Minimum Variance Portfolio (the risk return trade off with two risky assets portfolios) ›
»
Nick's picture

if there is always a comma

Submitted by Nick on 16 February, 2015 - 11:53.

if there is always a comma after the city, you can look for the comma using the FIND function, then work back

in A1:
800 Town And Country Blvd Houston, TX
in B1: =FIND(",",A1,1)
in C1: =FIND(" ",A1,B1-10) (Adjust the 10 to extract the cities)
in D1: =MID(A1,C1,B1-C1)

=> Houston

»