Results 1 to 15 of 15

Google Sheets: Extracting Zip codes with in multiple forms.

Threaded View

  1. 06-24-2021, 04:10 PM #1
    CobaltMaven
    CobaltMaven is offline
    Registered User
    Join Date
    08-07-2019
    Location
    Cincinnati, OH
    MS-Off Ver
    2013
    Posts
    12

    Google Sheets: Extracting Zip codes with in multiple forms.

    Hello! I need help finding a way to extract zip codes... the problem is is that there are some with 4 numbers after the dash and some without. but i need to extract either way. i have included some samples below, edited for privacy.... The entire block of text below is in its own cell (per row)

    6572 Jenn Dr Payton Township Ohio 48044-5972 USA
    5900 Timber Place Ave. Groplick Kentucky 49859 USA
    5359 Midsummer ave. Porktown Kentucky 41741 USA
    1443 Elk trotter ave Cowcity Ohio 45756 USA
    Last edited by AliGW; 06-25-2021 at 08:03 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2020, 12:06 PM
  2. help with codes for extracting data
    By Navin Agrawal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2016, 04:02 PM
  3. [SOLVED] CHALLENGE: Extracting data from complex Excel Forms
    By buzzers88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2014, 03:24 PM
  4. Creating short forms for multiple codes
    By vgr in forum Excel General
    Replies: 7
    Last Post: 07-19-2014, 08:37 PM
  5. some codes to relate two user forms
    By bskaa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2013, 04:09 AM
  6. Extracting Metrics with Forms or Control
    By mycon73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2010, 04:32 AM
  7. What codes can make Excel Macro to submit forms on web
    By FayettevilleEagles in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 09:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1