Error in formula

[questiontask]

Hello,

I have an Excel sheet and I want to concatenate two columns into a line that should be used afterwards for a macro function in Word.

The sheet looks like this:

A B C D
Identifier Author Journal Note

An example for an identifier of colum A: Achtman2008NRW
An example for a note of colum D: 375

I want to concatenate columns A and D. The result should look like this: ReplaceEndnoteRef 375, "Achtman2008NRW"

I am trying it with the following formula:

="ReplaceEndnoteRef "&D2&", "&CHAR(34)&A2&CHAR(34)

However, it does not work (#NAME?). It seems like the CHAR(34) cannot be processed. What could be the problem?

Note:

="ReplaceEndnoteRef "&D2&", "&A2 works, but it produces ReplaceEndnoteRef 375, Achtman2008NRW (so " is missing).

[martindwilson]

is it in german?

=ZEICHEN(34)

[questiontask]

Oh yes, thanks a lot. That solved it. Never would have thought of that!