fischXcell2
New Member
- Joined
- May 24, 2024
- Messages
- 9
- Office Version
- 2024
- 2021
- Platform
- Windows
- MacOS
Hi,
I need to create an inventory worksheet that includes the serial number and the item name. The Item name is easy because they are sequential digits, so I can just drag down, but that doesn't work with the serial numbers.
I searched for a function or formula to help with this and I found a post that was close to what I'm looking for, but not quite. In addition, I'm too much of a newbie to understand the suggested formulas completely. For example, I STILL don't understand the ADDRESS function even though I've read the description 3 times!
I have to play around with it more to see if I can understand how it works. Same with SUBSTITUTE.
I understand the LEFT function and that helped to this point: =LEFT(A2, 6). This gave me ABC0DE, but then how do I add the A, B, C, D and so on. Is there a way to incorporate the =CHAR(64+ROW(1stCELL)) and somehow concatenate with the LEFT function?
Thanks in advance.
I need to create an inventory worksheet that includes the serial number and the item name. The Item name is easy because they are sequential digits, so I can just drag down, but that doesn't work with the serial numbers.
I searched for a function or formula to help with this and I found a post that was close to what I'm looking for, but not quite. In addition, I'm too much of a newbie to understand the suggested formulas completely. For example, I STILL don't understand the ADDRESS function even though I've read the description 3 times!

I understand the LEFT function and that helped to this point: =LEFT(A2, 6). This gave me ABC0DE, but then how do I add the A, B, C, D and so on. Is there a way to incorporate the =CHAR(64+ROW(1stCELL)) and somehow concatenate with the LEFT function?
Serial # | Item |
ABC0DEA | 3456 |
ABC0DEB | 3457 |
ABC0DEC | 3458 |
ABC0DED | 3459 |
Thanks in advance.