Problem Concatenating Strings In Excel 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Galey - 01 Dec 2006 20:26 GMT

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?

Reply to this Message

Andy Pope - 01 Dec 2006 20:39 GMT

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

> I have Excel 2000 and am having trouble concatenating the contents of two
> cells.
[quoted text clipped - 6 lines]
> However, what shows up in cell G8 is #Name? instead of the string D46833
> that I expected. What could be wrong?

Reply to this Message

Ron Rosenfeld - 01 Dec 2006 20:42 GMT

>I have Excel 2000 and am having trouble concatenating the contents of two
>cells.
[quoted text clipped - 6 lines]
>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

Reply to this Message

Rate this thread: