Results 1 to 2 of 2

Thread: Excel Formatting Help.

  1. #1

    Excel Formatting Help.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I need some help with excel formatting.

    I am trying to paste some questions in Excel, but I don't no how to format that in correct way and seeking a help with professional.

    I want to save some questions from net and want to prepare from it for my exams.

    The questions are like this.

    First there would be a passage, and a passage contains 4 to 6 questions.

    I don't no how to keep passage in excel and how to keep those 4 to 6 multiple option questions below that passage.

    If someone could provide me a sheet on it i would appreciate and pray for you guys, please help me in this.

    Attached a sample in word, but I need to format this in Excel.

    Please help.
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi there,

    The first thing you need to do is turn your text into proper paragraphs in Word. Right now there is a hard return after every line.

    After you fix that, you should be able to copy a paragraph into a single cell. I think you should be good to go once you get that cleaned up.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •