Thread: [Solved] Excel 2010- What does this formula mean and how does it work
View Single Post
 
Old 10-31-2012, 09:18 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,371
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The "AA101 " part of the formula simply outputs "AA101 ". Fairly simple.
The next part, which could be reduced to "&CHAR(ROW()+64)" takes the row number, adds 64 to it, then expresses that as as ASCII character. Everything's sweet if you don't want more than 26 rows.

At its simplest, you can get the sequence expressed in the second part of your post by changing the first part of the formula, so it becomes:
="A000 1A1"&CHAR(ROW()+64)

If you're wanting something more sophisticated than that, you'll need to say exactly what you require.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote