Try this...

A1 = 2
B1 = 6
C1 = 0

Enter this formula in A2 and copy across as needed:

="A"&A1

--
Biff
Microsoft Excel MVP


"PL" wrote in message
...
Excel 2003

In row 1, 2, 6 , 0, ....
In row 2, I want A2, A6, A0, ...

What's the formula for inserting a letter?

Thanks