autofill column with increments

LFKim2018

Active Member
what is the formula to populate a column with alphanumeric string?
the string is to be used as product code..
say, starting at LFK101 - LFK102 - LFK103 (increment) so on down..
the string can be any number of letters and numbers..
like A1, ABC123, XYZ110.... the letter is always at the left and the numbers are at the right side of the string..
maximum letter = 10; maximum number to reach = 10,000
many many thanks
 
Last edited:

jtakw

Well-known Member
Hi,

You don't need a formula.

Enter the First Product Code in cell, Select that cell, left click on the cell Handle (little "square" at lower right corner of cell) and drag down as far as you need:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">LFK101</td><td style=";">A1</td><td style=";">ABC123</td><td style=";">XYZ110</td><td style=";">JIWEHUISEV005</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">LFK102</td><td style=";">A2</td><td style=";">ABC124</td><td style=";">XYZ111</td><td style=";">JIWEHUISEV006</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">LFK103</td><td style=";">A3</td><td style=";">ABC125</td><td style=";">XYZ112</td><td style=";">JIWEHUISEV007</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">LFK104</td><td style=";">A4</td><td style=";">ABC126</td><td style=";">XYZ113</td><td style=";">JIWEHUISEV008</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">LFK105</td><td style=";">A5</td><td style=";">ABC127</td><td style=";">XYZ114</td><td style=";">JIWEHUISEV009</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">LFK106</td><td style=";">A6</td><td style=";">ABC128</td><td style=";">XYZ115</td><td style=";">JIWEHUISEV010</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">LFK107</td><td style=";">A7</td><td style=";">ABC129</td><td style=";">XYZ116</td><td style=";">JIWEHUISEV011</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">LFK108</td><td style=";">A8</td><td style=";">ABC130</td><td style=";">XYZ117</td><td style=";">JIWEHUISEV012</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">LFK109</td><td style=";">A9</td><td style=";">ABC131</td><td style=";">XYZ118</td><td style=";">JIWEHUISEV013</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">LFK110</td><td style=";">A10</td><td style=";">ABC132</td><td style=";">XYZ119</td><td style=";">JIWEHUISEV014</td></tr></tbody></table><p style="width:6.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet248</p><br /><br />
 

Some videos you may like

This Week's Hot Topics

Top