New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Need Help

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Re: Need Help

Postby Kevin UK » Tue Mar 22, 2016 1:36 am

Hi

Assuming that you want to start in A1? One way:

Code: Select all
=123+(CEILING(ROW(),4)/4)-1&"-"&CHAR(64+MOD(ROW()-1,4)+1)


and copy down.
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 37 guests

cron