Results 1 to 8 of 8

Separating data with spaces and putting in two different cells

Threaded View

multimediocrity Separating data with spaces... 08-18-2009, 05:28 PM
NBVC Re: Separating data with... 08-18-2009, 05:34 PM
GuruWannaB Re: Separating data with... 08-18-2009, 05:34 PM
multimediocrity Re: Separating data with... 08-18-2009, 05:36 PM
GuruWannaB Re: Separating data with... 08-18-2009, 05:38 PM
GuruWannaB Re: Separating data with... 08-18-2009, 05:42 PM
adumbstudent Re: Separating data with... 02-18-2013, 03:23 PM
arlu1201 Re: Separating data with... 02-19-2013, 01:52 AM
  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2007
    Posts
    25

    Separating data with spaces and putting in two different cells

    My issue is complicated. I need to take data from a cell that has a space "cherry banana", and make it into two cells "cherry" and "banana". I want to duplicate my line on which the data resides, if possible.

    What I have is a sheet like this:

    IDs Data
    1   banana
    2   apple
    3   cherry apple
    4   cherry banana apple
    5   apple
    and I need to turn it into this:

    IDs Data
    1   banana
    2   apple
    3   cherry
    3a  apple
    4   cherry
    4a  banana
    4b  apple
    5   apple
    Any idea how I can do this?

    If not, then how do I simply parse out my data in a cell to other cells using the space as the delimiter?

    Thanks,
    Multi
    Last edited by NBVC; 08-18-2009 at 09:01 PM.
    Need a website or other media? Visit Amalgam Web and Media (http://www.amalgamweb.com) today for a free quote on any custom project.

Thread Information

Users Browsing this Thread

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

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