Share via

Concatenate function in Excel

Anonymous
2016-05-23T17:43:16+00:00

Windows 7 Professional SP1

Excel 2010 14.0.6129.5000 (64-bit)

Contents of text-format Cell D2:   4246040006683090040716

Contents of text-format Cell E2:   4431066097083309889939

Contents of Cell C2:   =CONCATENATE(D2,E2)

The concatenate function will not show me the concatenated values, only the formula.  If I choose Evaluate Formula on the formulas  tab, I get the message:  "The cell currently being evaluated contains a constant."

What is wrong; why won't Excel concatenate the cell contents?  Any help would be appreciated.

Jane

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-05-23T18:05:35+00:00

Your formula was typed into a cell that had previously been formatted as text.

Delete the formula, format the cell as General

Now re-enter the formula (or its shorter equivalent =D2&E2)

and all should be  well

best wishes

Was this answer helpful?

3 people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2016-05-23T17:55:10+00:00

Hi,

Check the format of C2, guessing it is TEXT, change it to general, click in the formula and enter.

Was this answer helpful?

2 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-23T18:13:33+00:00

    Thank you both, JP & Bernard.  You were right and my problem is solved.

    Jane

    Was this answer helpful?

    0 comments