Concatenate Failure

[Guest]

I am attempting to use the concatenate text function in
Excel 2000 as follows: =concatenate(a3,a4,a5) placed in
cell a1 with text strings in cells a3, a4, and a5. I
assumed that the data from cells a3, a4, and a5 would
magically appear in cell a1. What appears in cell a1 is
the actual text =concatenate(a3,a4,a5).

This seems to be the problem with all the text functions I
have tried in Excel 2000.

Any help would be appreciated.

 

[Max]

You might accidentally be in formula view?

Click Tools > Options > Uncheck "Formulas" > OK

[ or press Ctrl + ~
"~" - the tilde key, just to the left of the "1" key)]

And instead of CONCATENATE, maybe try the shorter

: =A3&" "&A4&" "&A5

[the above will also put a blank space in-between - usually desired]

 

[Gord Dibben]

If not in Formula View, the formula entry cell(A1) may have been pre-formatted
as Text.

Try changing format to General then re-entering by hitting F2 and <ENTER>

Gord Dibben Excel MVP

 

[Guest]

Thanks for the tip. I had to format the cell to text and
then back to general for the real text to show up instead
of the formula. Strange Microsoft Phenomenon!!

-----Original Message-----
You might accidentally be in formula view?

Click Tools > Options > Uncheck "Formulas" > OK

[ or press Ctrl + ~
"~" - the tilde key, just to the left of the "1" key)]

And instead of CONCATENATE, maybe try the shorter

: =A3&" "&A4&" "&A5

[the above will also put a blank space in-between - usually desired]

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----

I am attempting to use the concatenate text function in
Excel 2000 as follows: =concatenate(a3,a4,a5) placed in
cell a1 with text strings in cells a3, a4, and a5. I
assumed that the data from cells a3, a4, and a5 would
magically appear in cell a1. What appears in cell a1 is
the actual text =concatenate(a3,a4,a5).

This seems to be the problem with all the text functions I
have tried in Excel 2000.

Any help would be appreciated.

.

 

[Guest]

The cell was formatted as general. I formatted to text
then back to general and that fixed the problem. Thanks!

 

[Max]

You're welcome!
Glad to hear you got it sorted out.
Thanks for the feedback.