Replies

This happens when your Field names cannot be found by Word. When using an Excel file as a Data Source, the field names MUST be in the first row of the the Spreadsheet and there can be no blank rows between the field names and the actual data. Correct your Excel list, save and then try the merge again.

Go to the View Menu, trace down to Toolbars, trace over and down to Customize. Go to the Toolbars tab, Select Menu Bar, Click the Reset button on the right. Close the box and your Tools menu should now appear.

Have you checked your language settings? Under the Tools menu–Go to Language–Set Language. Make sure that you have a default language set and uncheck the Automatically detect language setting. This may help.

comic]]The problem is that you have a comma after vlookup instead of enclosing it all in parentheses. It should be:

=IF(A2=1,VLOOKUP(G2,SHEET2!C10:D12,2), VLOOKUP(G2, SHEET2!F10:G12,2))

I would also suggest naming your lookup ranges. This will make the function much easier to work with. My above function says: “If A1=1 the go to Sheet 2 to the lookup table contained in cells C10:D12 and look for the corresponding information in the second column. If A1 does not equal 1 then go to Sheet 2 to the look up table contained in Cells F10:G12 and look for the corresponding information in the second column. I hope this is helpful!]

Excel has a TRIM function in EXCEL that will remove all spaces except the spaces between words. =TRIM(A1) would be the syntax. If you put this function in a blank column and then filled down to include all 500 rows then it would take out the leading spaces. You could then either hide the original column or copy the new entries and then use a Paste Special to paste the values back in the original spots. I hope this helps!

It sounds like you have the continuation line for the footer active. Try this:

Switch to Normal View
Double click on the Footnote reference number in the document text. This will split your screen so that you will see the footnote at the bottom.

You should also see where it says Footnotes….and then a drop down box that says all footnotes.

Click the down arrow and choose Footnote separator and then click the reset button.

Click the down arrow again and choose Footnote Continuation Separator and then click the reset button. Then click close.

Change your view back to Page layout and see if it worked.

If you still have the line, you want to change the Footnote Continuation Separator to look like the Footnote Separator.

Switch back to Normal View and double click one of the footnote reference numbers.

Click the down arrow and choose Footnote Separator. Select the line and copy it. Click the down arrow and choose Footnote Continuation Separator. Select the line there, delete it, and then paste. Click Close and now you have a short line instead of one that goes all the way across the bottom.

I hope this helps!