Thread: formula for inserting a letter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sunil Jangid Sunil Jangid is offline
external usenet poster
  
Posts: 2
Default 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
Reply With QuoteReply With Quote