Share via

Concatenate in table header

Anonymous
2016-02-06T18:30:04+00:00

Hi.  What should be a simple solution is turning out to be a head-scratcher and quite frustrating.

I have a range, formatted as a table (using the Excel feature), that will not seem to allow me to concatenate in the table header.  One cell (different sheet) will have the month entered, which I want to concatenate with text in the table header cell.  Every time I try to join the information, the table header changes to a "0".

Concatenation is easy with regular cells, I have just never had to try to do this in a table and am puzzled why it doesn't either error or return the expected results.

I appreciate any help or insight.

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-02-06T18:40:27+00:00

Hi Scott

Column headers are Field Names and therefore are static text. Only way around would be to uncheck 'Header Row' under Design tab. You can enter a formula in the first row but will lose functionality of the Table Headers [Filed Names].

Regards

Khalid Suddle

Was this answer helpful?

9 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-02-08T21:03:01+00:00

    Thank you for the information.  Althoughy I wanted to keep the headers, it helped to realize that was creating the problem.  Thank you.

    Was this answer helpful?

    0 comments