Change Column headers from numeric to alpha

[Diane S]

How do you change column headers from numeric to alpha. I need for the concatenate function. Excel 2010.

[ben_hensel]

I don't understand the question, in several directions.

1) Concatenate itself just takes a cell reference?
2) Do you mean, like, changing excel so that cell A1 is referred to as 1-1 or something? That sounds like a really bad idea in a variety of ways.

What is it you need to do?

[Diane S]

I use an (=) sign: =A1&D1&E1 to concatenate my cells. I then copy the formula down. I just received the 2010 version. When I type the numerics (=11&41&51), excel does not recognize.
So, I just want to change column headings to alpha.

Why do you think this is a bad idea? I have always joined my cells in this manner -- it is simple and swift.

Thank you.

[FDibbins]

if you are in fact using ( then try removing them and just use =11&41&51. otherwise, when you type =A1&D1&E1 what results do you get?

[icestationzbra]

if i understand you correctly, use the following navigation while Excel 2010 is open:

ALT + F + I

> Formulas > Working with Formulas > Uncheck R1C1 reference style

as far as i know, with R1C1 style, you cannot enter your Concatenate formula like you do with regular style (A1, B1 etc.).

if you want to concatenate values in A1, D1 and E1 and show the results in F1, while in the R1C1 style, your formula would be:

=RC[-5]&RC[-2]&RC[-1]

[Diane S]

icestationzbra - that did work! Thank you for the help!