Problem Concatenating Strings In Excel 2000

[Phil Galey]

I have Excel 2000 and am having trouble concatenating the contents of two
cells.

In cell E8 I have the letter D. In cell F8 I have the number 46833. In
cell G8, I typed the following:

=CONCATENATE(E8,F8)

However, what shows up in cell G8 is #Name? instead of the string D46833
that I expected. What could be wrong?

 

[Andy Pope]

Hi,

Are you sure you have spelt CONCATENATE correct in you spreadsheet. As
your posted formula work for me.

Another alternative to the concatenate formula is to use &

=E8 & F8

Cheers
Andy

 

[Ron Rosenfeld]

I have Excel 2000 and am having trouble concatenating the contents of two
cells.

In cell E8 I have the letter D. In cell F8 I have the number 46833. In
cell G8, I typed the following:

=CONCATENATE(E8,F8)

However, what shows up in cell G8 is #Name? instead of the string D46833
that I expected. What could be wrong?

Perhaps there is an extra non-printing character in your formula.

As pasted from this message, your formula works correctly with the data you
specify.
--ron