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