How do I get the concatenate function in Excel to display results?

[Rob]

I'm using =CONCATENATE(g40,g41) and that is what is displayed in the cell.
I'm not getting the combined text strings from cells g40 and g41. When
setting up the function arguments, the expected results are shown, but when I
click "go" the spreadsheet doesn't display the correct result. I've tried
just using text instead of cell numbers and I get the same results.

Thanks.

 

[Pete]

It sounds like the cell is formatted as text. Use Format | Cell |
Number (tab) and change it to General. Double-click in the cell (as if
to edit it) then press <enter>.

Incidentally, you can reduce typing by changing your formula to:

= G40 & G41

It means the same thing.

If this doesn't cure it, you probably have the calculation mode set to
manual. Press F9 to re-calculate at any time. To change to automatic
calculation go to Tools | Options | Calculation (tab) and select
automatic.

Hope this helps.

Pete

 

[daddylonglegs]

Do you mean that the cell just shows the actual formula?

If so select cell and use

EDIT > REPLACE

and replace = with =

BTW a simpler formula is

=G40&G41

 

[Bob Phillips]

or maybe you have the wrong view, check Tools>Options>View and ensure that
Formulas is not checked.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Rob]

Thanks. I cut and pasted what you had below and it worked. Just for fun I
re-entered =CONCATENATE(g40,g41) and it worked too!