Results 1 to 9 of 9

Reorder elements a cell using arrays, split & join

Threaded View

k8_dog Reorder elements a cell using... 01-10-2011, 07:44 PM
DonkeyOte re: Reorder elements a cell... 01-10-2011, 07:54 PM
k8_dog re: Reorder elements a cell... 01-10-2011, 08:11 PM
k8_dog Re: Reorder elements a cell... 01-11-2011, 08:54 PM
DonkeyOte Re: Reorder elements a cell... 01-12-2011, 04:03 AM
snb Re: Reorder elements a cell... 01-12-2011, 04:37 AM
DonkeyOte Re: Reorder elements a cell... 01-12-2011, 06:07 AM
snb Re: Reorder elements a cell... 01-12-2011, 06:18 AM
k8_dog Re: Reorder elements a cell... 01-12-2011, 01:58 PM
  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Oakland, USA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Reorder elements a cell using arrays, split & join

    In Excel, I work with lists that look like this:

    Smith: My Homeland, Collected Poems
    Smith: Dr. Cuteroff, Collected Poems
    Smith: Snark, Collected Poems
    Chiu: Always, Anthology Of New American Literature
    Jones: Our Way To start The Day, Humble Pie
    Smith: Looking In
    Zhdenka: Interstices, Anthology Of New American Literature

    The format is generally Author: WOrk, Publication. Sometimes there is no Publication.

    I would like to be able to select the cells with these works and run a macro that changes the order to:

    Author: Publication - Work

    like this:

    Smith: Collected Poems - My Homeland
    Smith: Collected Poems - Dr. Cuteroff
    Smith: Collected Poems - Snark
    Chiu: Anthology Of New American Literature - Always
    Jones: Humble Pie - Our Way To start The Day
    Smith: Looking In
    Zhdenka: Anthology Of New American Literature - Interstices


    I have done some VBA stuff in the past, but nothing with split, join and arrays, which I think may be needed here. Any suggestions, advice or links will be greatly appreciated.

    Thanks,
    k8
    Last edited by k8_dog; 01-12-2011 at 01:59 PM.

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