formula for inserting a letter
 

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

adding letter
 

+("A"&cellreference)



PL wrote:

formula for inserting a letter
30-Dec-09

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

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Developing Applications With Visual Studio.NET
http://www.eggheadcafe.com/tutorials...cations-w.aspx

formula for inserting a letter
 

Insert
="A"&A1
in B1 and drag the same ahead.
--
Thanx in advance,
Best Regards,

Faraz


"PL" wrote:

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

formula for inserting a letter
 

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