formula for inserting a letter

[PL]

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

 

[Sunil Jangid]

+("A"&cellreference)



PL wrote:

formula for inserting a letter
30-Dec-09

Excel 200

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

What's the formula for inserting a letter

Thanks

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Developing Applications With Visual Studio.NET
http://www.eggheadcafe.com/tutorial...d-cd5e366a4ce3/developing-applications-w.aspx

 

[Faraz A. Qureshi]

Insert
="A"&A1
in B1 and drag the same ahead.

 

[T. Valko]

Try this...

A1 = 2
B1 = 6
C1 = 0

Enter this formula in A2 and copy across as needed:

="A"&A1