+ Reply to Thread
Results 1 to 8 of 8

Extract State Code from Single Cell

Hybrid View

  1. 10-11-2013, 10:08 AM #1
    maacmaac
    maacmaac is offline
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Re: Extract State Code from Single Cell

    All solutions worked with exception of last one. Fotis, I'm getting an error on formula. It appears the error is occuring on 'Find' portion of the formula. Thanks.
    Reply With QuoteRegister To Reply
  2. 10-11-2013, 10:14 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Extract State Code from Single Cell

    All the other solutions work great. Also mine!
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Extract Zip Code from the address in a single cell
    By maacmaac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 11:29 AM
  2. Data extract by state
    By mathanraj76 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-04-2013, 05:24 AM
  3. [SOLVED] GetMatch plus VBA Code to Extract Matched Numbers from 2 Single Cells
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-18-2013, 05:08 PM
  4. [SOLVED] city, state, zip from a single cell to multiple cells
    By wjs2002 in forum Excel General
    Replies: 3
    Last Post: 04-29-2005, 02:06 AM
  5. 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

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