| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Renaming Sequential Rows to create serial numbers
I am new to Excel.
I have the following cells in one column in sequential rows: aas aas aas aas aas bbc bbc bbc bbc bbc I want to make a command to change these to: aas001 aas002 aas003 aas004 aas005 bbc101 bbc102 bbc103 bbc104 bbc105 How do I change or rename a series of cells in a column, increasing the digit by 1 while retaining the three letter prefix? I'm trying to create product serial numbers in a worksheet with hundreds of rows of products. Thanks, Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reversing numbers to create dates | Excel Worksheet Functions | |||
| How do I create a form template that will be sequential numbered | Excel Discussion (Misc queries) | |||
| How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
| How can i print sequential page numbers 1 to 10, if i have one wo. | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
