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" a...
OliverScheurich
May 28, 2025Gold Contributor
="U02_"&TEXT(ROW(A1),"00")&"P"This returns the intended result if i correctly understand what you are looking for.