Results 1 to 8 of 8

Sorting MCQ questions alphabetically

Threaded View

  1. #3
    Registered User
    Join Date
    11-07-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2013
    Posts
    6

    Question Re: Sorting MCQ questions alphabetically

    It works by adding spaces, which is good, but it does not concatenate all the cells into one line.
    I've attached sample file with original data in A1:A, Your formula applied in B1:B. And sample of what I'm trying to achieve in C1:C

    Thanks for helping, hopefully I can get some advice how to modify your original formula.

    i'm not sure if my idea is good, but maybe we can then concatenate cells using if statement, till the moment we see a a blank cell now as produced by your formula above
    Attached Files Attached Files
    Last edited by kokoman789; 11-08-2013 at 12:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula in sorting alphabetically
    By felixpanganiban in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2012, 01:56 PM
  2. sorting sheets alphabetically
    By KIRSTA1967 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 04:05 AM
  3. Sorting SOME Worksheets Alphabetically
    By wjsok85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2009, 10:41 AM
  4. Sorting certain sheets alphabetically
    By SOS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2008, 11:21 AM
  5. Sorting Alphabetically
    By Jack in forum Excel General
    Replies: 1
    Last Post: 01-15-2005, 05: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1