Forum Discussion
editor01
May 28, 2025Copper Contributor
Populate numbers/letters in long list...???
Hello - I often need to populate long lists in excel and would like to know if there is any way to this in cells using numbers/characters/letters? For example... I have a cell filled with "U02_01P" and I would like to fill down remaining cells changing the numbers before "P" to the next sequential number ("U02_02P, U02_03P....). Is there an easy way to do this?? I'm not an excel expert - so an
y help would be appreciated!
3 Replies
Sort By
- OliverScheurichGold Contributor
="U02_"&TEXT(ROW(A1),"00")&"P"
This returns the intended result if i correctly understand what you are looking for.