Message-ID:

We are drowning in information but starved for knowledge. -- John Naisbitt, Megatrends

computers / microsoft.public.excel.misc / FORMULA TO EXTRACT CITY AND STATE

FORMULA TO EXTRACT CITY AND STATE

<221858f7-8095-4fa7-a544-09d79a95f609n@googlegroups.com>

https://news.novabbs.org/computers/article-flat.php?id=1794&group=microsoft.public.excel.misc#1794

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:6214:94d:b0:65b:557:f699 with SMTP id dn13-20020a056214094d00b0065b0557f699mr13715qvb.6.1695804921534;
Wed, 27 Sep 2023 01:55:21 -0700 (PDT)
X-Received: by 2002:a9d:61d4:0:b0:6c6:1de4:d48f with SMTP id
h20-20020a9d61d4000000b006c61de4d48fmr314707otk.3.1695804921157; Wed, 27 Sep
2023 01:55:21 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Wed, 27 Sep 2023 01:55:20 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=102.88.63.37; posting-account=zNM-ywoAAABe10BnZQ3z-P2aCtiW8Mhp
NNTP-Posting-Host: 102.88.63.37
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <221858f7-8095-4fa7-a544-09d79a95f609n@googlegroups.com>
Subject: FORMULA TO EXTRACT CITY AND STATE
From: ogechukwuohaji@gmail.com (Ogechukwu Ohaji)
Injection-Date: Wed, 27 Sep 2023 08:55:21 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1259

by: Ogechukwu Ohaji - Wed, 27 Sep 2023 08:55 UTC

Hello,

Please, I need a formula to extract the city and state from an address in A1 to B1.

Example:
Amara Olu St, Agidingbi 101233, Lagos

City and state in the example is Agidingbi and Lagos.

I am new to google spreadsheet.

Thank you
Ogechukwu

Subject	Author
FORMULA TO EXTRACT CITY AND STATE	Ogechukwu Ohaji