Hi there,
I'm having an annoying issue merging from Excel 2000 to Word 2000 from a column that has either a number or text. Specifically, my source spreadsheet has a column (with the header 'Stage') that draws its data from a column in a different worksheet in the same document, using a basic formula that reads:
=IF('Scores Assessment'!I10<>"",'Scores Assessment'!I10,"")
The column Scores Assessment referenced in the above formula can have one of 5 values, which are: 1, 2, 3, 4, or TOEFL (these are class levels at our school).
When I merge into the Word document, the Stage information merges fine for the numbered stages (1-4) but for the value 'TOEFL' I get a 0 (zero). I've tried switching the formatting of the original data column and/or the merged column to Text, General, and Custom, but I get the same result.
In the Word doc the merge info for this item is:
{ MERGEFIELD "Stage" }
I've tried removing the quotes around "Stage" in that, but it didn't help either.
I'm sure the solution is simple, but I can't figure it out. Unfortunately, I can't seem to attach the relevant files on here--the file sizes are too large.
Thanks for any tips!
Bookmarks