Home |
Search |
Today's Posts |
#1
|
|||
|
|||
reading data inaccurately when merging from Excel to Word
I am trying to merge from Excel into Word. One of the columns contains date
format data which is generated by a forumal. The same column also contains some records which return "N/A" and is in text format, manually imputted. The merge instruction within Word is: MERGEFIELD First_Board_T \@"YY" However this will not recognise "N/A" and merges this entry as a date. How can I tell word to migrate the exact data contained within the column? Grateful for your assistance. Loz |
#2
|
|||
|
|||
You will need a conditional field
{IF {MERGEFIELD First_Board_T} "N/A" "{MERGEFIELD First_Board_T \@ "YY"}" "N/A"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Loz wrote: I am trying to merge from Excel into Word. One of the columns contains date format data which is generated by a forumal. The same column also contains some records which return "N/A" and is in text format, manually imputted. The merge instruction within Word is: MERGEFIELD First_Board_T \@"YY" However this will not recognise "N/A" and merges this entry as a date. How can I tell word to migrate the exact data contained within the column? Grateful for your assistance. Loz |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
How do you keep the currency format when merging data from Excel? | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Format Excel data for merging in Word | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge |