Is there a way to transfer MSWord numbering bullets to MSExcel column

0 votes
I've been creating my question list in MS Word 2010 so far. These questions are arranged using numbering starting at 1 in a single MSWord document. the first inquiry, etc.

Could the contents of each bullet be transferred to an MSExcel cell, I wondered? I would therefore have a cell with 20 rows, each holding one question if I had 20 questions.

I want to import 300 questions into Excel, which is why I'm asking.
Nov 17 in Others by Kithuzzz
• 20,660 points
20 views

1 answer to this question.

0 votes

Your numbered bullets can be copied from Excel to Word and then divided using worksheet functions in Excel. However, using the built-in Excel commands makes it really simple.

In Word:

  • Increase the width on the hanging indent on your numbered list. It will make the conversion in Excel easier to deal with.
  • Select your bullets and copy them.

In Excel:

  • "Paste Special" the copied text into Excel using the Match Destination Formatting option.
  • Select the cells you pasted the bullets by the number of digits in the bullets (i.e., first do 1-9, then do 10-99, etc.)
  • With the cells selected, choose the Text to Columns command from the Data tab on the ribbon.
  • Make sure that the 'Fixed Width" radio box is selected on the dialogue box that comes up, then move to the next step.
  • Adjust the brake lines so that there are three fields: one with the number + period, another with the spaces between the numbers and text, and the third with the text.
  • Moving to the next step - select the second field (the spaces) and click the "Do not import column (skip) radio button.
  • Click finish and the bullets are imported.
I hope this helps you.
answered Nov 17 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Is there a way to search the iOS app store online?

Apple finally made it possible to just use ...READ MORE

answered Sep 21 in Others by rajatha
• 7,480 points
147 views
0 votes
1 answer

Is there a way to generate high resolution PNGs of iOS emoji?

Step 1: Visit Google Play Store on ...READ MORE

answered Nov 4 in Others by gaurav
• 22,040 points
50 views
0 votes
0 answers

Is there a way to generate high resolution PNGs of iOS emoji?

I have been able to find 160x160 ...READ MORE

Sep 23 in Others by gaurav
• 22,040 points
53 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer

Adding Signature Line Word-Excel

Since there doesn't appear to be a ...READ MORE

answered Oct 14 in Others by narikkadan
• 37,660 points
46 views
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
93 views
0 votes
1 answer

Convert word document to excel

See the solution here: https://superuser.com/questions/747197/how-do-i-copy-word-tables-into-excel-without-splitting-cells-into-multiple-rows In essence, I had ...READ MORE

answered Oct 23 in Others by narikkadan
• 37,660 points
33 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
42 views
0 votes
1 answer
0 votes
1 answer

Is there a way to SUMIFS with multiple criteria + true or false?

You can add this as the  last criteria: =SUMIFS(STORE!$C$6:$C$1000;STORE!$A$6:$A$1000;""&SUMMARY!$D$5&"";STORE!$D$6:$D$1000;""&SUMMARY!$C$9&"";STORE!$E$6:$E$1000;""&SUMMARY!D8&"";STORE!$AA$6:$AA$1000;TRUE) STORE!$AA$6:$AA$1000: ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
72 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP