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!