+ Reply to Thread
Results 1 to 7 of 7

Looking for formula to extract state names from free text cell... HELP!

Hybrid View

  1. #1
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Looking for formula to extract state names from free text cell... HELP!

    This can be accomplished by doing look up of the state names. For this you would need to create a list of states and use formula.

    Please see attached file with states names and a formula in B2
    Attached Files Attached Files
    Last edited by AlKey; 10-21-2014 at 02:51 PM. Reason: Updated formula on spreadsheet.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula not working to convert state names to abbreviations
    By moorea in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-30-2014, 04:18 AM
  2. [SOLVED] Extract State Code from Single Cell
    By maacmaac in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-11-2013, 10:14 AM
  3. How to get table names from access to free text?
    By Baker in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2012, 08:10 PM
  4. Extract Post Code data from a free text field
    By DGillham in forum Excel General
    Replies: 5
    Last Post: 07-05-2010, 03:38 AM
  5. [SOLVED] Extract city, state and zip code from a single cell
    By jajoseph@zoominternet.net in forum Excel General
    Replies: 6
    Last Post: 02-06-2005, 10:06 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