Results 1 to 8 of 8

Sorting MCQ questions alphabetically

Threaded View

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

    Question Sorting MCQ questions alphabetically

    I have a text file with MCQ's. after importing it every line got a separate cell
    The questions are not numbered and do not have any spaces between them.

    Some have ABCD. some have ABCD E as answers. As you see some questions have multiple lines (sometimes even 4 lines).. same holds for answers. The only thing that I can think of is that the first Letter of the question is Always capital and is never starting with the followin 3 characters "A. " or "B. " , "C. " or "E. " .. etc

    This is a bout 150000 lines of data, and what I'm trying to achieve is each question in a separate cell (possibly using concatenate function and all the cells sorted alphabetically

    they look in a similar format:

    Someone with history of shortness of breath you would
    suspect
    A. asthma.
    B. emphysema.
    C. typhoid.
    D. cardiac insufficiency.

    so that they would look like "Someone with history of shortness of breath you would suspect A. asthma. B. emphysema. C. typhoid. D. cardiac insufficiency." all in one cell

    Thanks , i would really appreciate any help I could get in achieving this
    Last edited by kokoman789; 11-08-2013 at 03:08 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