Results 1 to 6 of 6

How to Parse Values in One Cell into Two Cells

Threaded View

lyndy256 How to Parse Values in One... 08-09-2013, 05:08 AM
amy_d2 Re: How to Parse Values in... 08-09-2013, 05:16 AM
:) Sixthsense :) Re: How to Parse Values in... 08-09-2013, 05:40 AM
lyndy256 Re: How to Parse Values in... 08-09-2013, 10:38 PM
amy_d2 Re: How to Parse Values in... 08-10-2013, 02:17 AM
lyndy256 Re: How to Parse Values in... 08-11-2013, 04:19 AM
  1. 08-09-2013, 05:08 AM #1
    lyndy256 is offline
    Registered User
    Join Date
    05-16-2013
    Location
    Chiang Mai, Thailand
    MS-Off Ver
    Excel 2010
    Posts
    34

    How to Parse Values in One Cell into Two Cells

    Hello,

    I have a worksheet with City and State in One cell. I would like to extract the state into a separate cell for easier analysis. Is there a formula to do this?

    See attached worksheet.
    Attached Files Attached Files
    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] Parse multiple values in a cell into separate rows
    By bcullers in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 01-25-2013, 03:03 PM
  2. [SOLVED] Parse out contents of cell to new cells
    By Elgreco in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-17-2012, 11:25 AM
  3. How to parse comma separated values in a cell & generate command
    By sirababu in forum Excel General
    Replies: 6
    Last Post: 07-19-2012, 01:58 PM
  4. Parse one cell into 2 or 3 cells
    By SueWithQuestion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2010, 10:52 AM
  5. Parse data from one cell to multiple cells
    By cchoo13 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2009, 01:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1