Results 1 to 21 of 21

How do I extract a 5 digit zip code from a column that may have a random number of text?

Threaded View

cmanlongat How do I extract a 5 digit... 05-10-2016, 02:56 PM
Mumps1 Re: How do I extract a 5... 05-10-2016, 03:19 PM
cmanlongat Re: How do I extract a 5... 05-10-2016, 03:39 PM
FDibbins Re: How do I extract a 5... 05-10-2016, 03:41 PM
cmanlongat Re: How do I extract a 5... 05-10-2016, 03:49 PM
Mumps1 Re: How do I extract a 5... 05-10-2016, 03:55 PM
cmanlongat Re: How do I extract a 5... 05-10-2016, 04:12 PM
Pete_UK Re: How do I extract a 5... 05-10-2016, 03:58 PM
Mumps1 Re: How do I extract a 5... 05-10-2016, 04:11 PM
cmanlongat Re: How do I extract a 5... 05-10-2016, 04:19 PM
Pete_UK Re: How do I extract a 5... 05-10-2016, 04:33 PM
cmanlongat Re: How do I extract a 5... 05-10-2016, 04:41 PM
Pete_UK Re: How do I extract a 5... 05-10-2016, 05:00 PM
jindon Re: How do I extract a 5... 05-10-2016, 05:18 PM
  1. #5
    Registered User
    Join Date
    05-10-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    12

    Re: How do I extract a 5 digit zip code from a column that may have a random number of tex

    Thanks for the tip.

    So attached is a sample workbook of what I'll be working on. As you can see under the "notes" column, there is a body of text with the zip code. I want to be able to extract only the zip code shown to the row over to the right (column E)

    Thanks to everybody for the help so far.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-19-2016, 01:11 AM
  2. Replies: 6
    Last Post: 08-31-2015, 03:08 PM
  3. [SOLVED] 5-digit Random Unique Alphanumeric Code
    By mcodden in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-15-2015, 04:32 PM
  4. [SOLVED] 5-digit Random Unique Alphanumeric Code
    By mcodden in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-15-2015, 02:39 PM
  5. [SOLVED] extract 10 digit number only from text string
    By visha_1984 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-06-2015, 09:42 AM
  6. [SOLVED] VBA to convert cell to text and ensuring 7 digit number all along in entire column.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-19-2013, 09:35 AM
  7. [SOLVED] Random 8 digit number?
    By KennyS in forum Excel General
    Replies: 6
    Last Post: 08-21-2006, 01:30 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1