+ Reply to Thread
Results 1 to 2 of 2

Re-order words within text string

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Re-order words within text string

    Hi guys,

    I'm curious if there's a way to take a text string and change the word order based the first letter of each word(alphabetically)

    Example:
    Original text: great vacation places for hiking in europe
    Desired text: europe for great hiking in places vacation

    Thanks in advance.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    35,777

    Re: Re-order words within text string

    Hi there. This can be done (with a bit of VBA). Here's a link to the original post:
    http://www.excelforum.com/excel-gene...ular-cell.html

    In your specific case, change the UDF to =SortWithinCell(A3," ",TRUE)

    File attached as illustration...
    Attached Files Attached Files
    Glenn



+ 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. Replies: 5
    Last Post: 03-21-2015, 04:14 AM
  2. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  3. VBA - Extract Words from Text String
    By NKRA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2013, 11:18 AM
  4. Extract a string of text between certain words
    By delboy2405 in forum Excel General
    Replies: 3
    Last Post: 01-17-2012, 12:40 AM
  5. Replies: 15
    Last Post: 04-16-2011, 04:01 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1