<div>
1. In the cell A1 put 1.<br>2. In the cel A2 put =A1+1<br>3. Copy A2, select A2-A999 and click paste.<br>4. Set B1 = CONCAT("C",TEXT(A1,"000"))<br>5. Copy B1, select B2-B999, and click Paste.<br><br>or you can use Visual Basic for Application (VBA) to generate the same:<br><br>alt-F11 to start editing VBA code.<br><br>&nbsp; &nbsp; Sub myLoop()<br>&nbsp; &nbsp; &nbsp; &nbsp; Dim k as Integer<br>&nbsp; &nbsp; &nbsp; &nbsp; For k=1 To 999<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cells(k, 1) = "C" &amp; format(k,"000")<br>&nbsp; &nbsp; &nbsp; &nbsp; Next k &nbsp; &nbsp;<br>&nbsp; &nbsp; End Sub<br><br>You can assign the Sub to a button:<br><a href="https://www.spreadsheetsmadeeasy.com/assign-button-macro/" rel="ugc">https://www.spreadsheetsmadeeasy.com/assign-button-macro/</a>
</div>


Technical Writer

Doug Van

<div>
Using Excel's SEQUENCE function, you can generate 999 instances of values in the format C001, C002, ... by putting the following formula in a single cell:<br><pre><code class="code-1 nolinks" id="code-20-43300083-1"><span>=TEXT(SEQUENCE(999),"\C000")</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content fr-view">
It seems that I cannot do this with the "sequence" formula... or can I?<br><br>I want to auto-populate a column with values in the following format:<br>C001<br>C001<br>all the way up to C999.<br><br>Is it possible to automate this in Excel / Google Sheets? I'm actually using Google Sheets but an Excel answer is likely equally valid. <br><br>Thank you.
</div>
</div>



It seems that I cannot do this with the "sequence" formula... or can I?
I want to auto-populate a column with values in the following format:
C001
C001
all the way up to C999.
Is it possible to automate this in Excel / Google Sheets? I'm actually using Google Sheets but an Excel answer is likely equally valid.
Thank you.

Is it possible to auto-populate a column of sequential values (w/leading zeros)?

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

google spreadsheets

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.

Google Workspace

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.