cell displays formula instead of value

J

Jeff Higgins

Hi,
Excel 2003 SP2
I have a new blank workbook,
and on a new blank worksheet
I format columns A - D as Text.

A1 = [This_]
B1 = [is_]
C1 = [text.]
D1 = [=CONCATENATE(A1, B1, C1)]

D1 now displays [=CONCATENATE(A1 ,B1, C1)]
instead if the expected [This_is_Text.]

Please help.
I have hours in this :((
Thanks
Jeff Higgins
 
B

Beege

Jeff
D1 should have been formatted as "general". Format it, re-type formula?
HTH

Beege
 
J

Jeff Higgins

Beege said:
Jeff
D1 should have been formatted as "general". Format it, re-type formula?
HTH

Beege
Click to expand...

Beege,
I guess that makes sense, after all
=CONCATENATE(A1, B1, C1) is text.

After all this, I think I'll grab a big piece
of bubble gum and take a stroll.

Appreciate the help, thanks.
Jeff
 
P

Pete_UK

A shorter version of your formula can be written as:

=A1&B1&C1

& is known as the concatenation operator (i.e. it "joins" strings
together).

Pete
 
J

Jeff Higgins

Pete_UK
A shorter version of your formula can be written as:

=A1&B1&C1

& is known as the concatenation operator (i.e. it "joins" strings
together).

Pete
Click to expand...
Thanks, &appreciate the note.
Jeff
Sorry if I emailed you.
 
Top