I'm creating an appendix in word from an excel document of 2 cells, one is a word, the other is a page number, and I want it to be formatted like this:






(ASC.PR.A)........................................ ..................................... 38

So I have the first part (ASC.PR.A) in one cell and the page number in the other, I need to add all the periods to about 200 of these, and I was wondering if there is a better way then going manually one by one typing the periods...can anyone help?

bump

any thoughts?

Hi Michael
Try this formula in a blank column in Excel which you can then read into MS Word. This is assuming the first part of you entry is in Column A Row 2 of course:

=A2&"............................"

Then copy this formula down to each row of your datasheet.
Hope this helps.
Good luck.
Tony

If you're selecting two columns in the spreadsheet and pasting the content into Word, I'd expect you to end up with a tab before the page numbers. If that's so, you need only set up the tabs to achieve the required result without typing a single full-stop <g> If your copy/paste is not inserting a tab, you should be able to do this with the wildcard options in Find and Replace.