MS Excel QuickTip - To quickly insert today's date into a cell use CTRL ;
| Avoiding truncating of data when merging from Excel to Word |
|
|
|
|
To override the truncating of characters when merging cells from Excel to Word that contain more than 255 characters. 1. Restore your mail-merge document to a normal document (Note: All filters/sort criteria will be lost so ensure you make a note of this first). Save and close the document. 2. Open the Tools menu and choose Options 3. Click the General tab and tick "Confirm conversion at open", click OK to accept 4. Re-open the Word document and re-create the Mail Merge - an extra step should appear that allows you to connect to the Excel Data via .DDE - choose this method 5. Re-set your filters/sort options 6. Perform merge and fields should no longer be truncated
|
| < Prev | Next > |
|---|
Northern Courses
| Wed 03 Feb @ 09:30 Prince 2 Foundation |
| Thu 04 Feb @ 09:30 Prince 2 Foundation |
| Wed 17 Feb @ 09:30 Prince 2 Practitioner |
| Thu 18 Feb @ 09:30 Prince 2 Practitioner |
| Thu 04 Mar @ 09:30 Prince 2 Revision |
Southern Courses
| Mon 22 Mar @ 09:30 Minute Taking Skills |
| Tue 23 Mar @ 09:30 Speedwriting Skills |
| Tue 23 Mar @ 09:30 MS Project Introduction |
| Wed 24 Mar @ 09:30 Speedwriting Skills |
| Wed 24 Mar @ 09:30 MS Project Intermediate |
Events Link
For a full events listing, click here
