Creating sequential text string of fixed length
"BDT" wrote:
Here is a better solution than the one I suggested earlier.
Try =CONCATENATE("Row ", ROW(), " ", TEXT(ROW(),"0000"))
then you can copy the row and Paste Special/value over itself to remove
all of the functions so it doesn't stay linked to the row number. It's just
text at that point.
hope this helps
"dhstein" wrote:
Hi - I need a formula that will generate text strings in rows like
row 1 0001
row 2 0002
row 3 0003
.
.
.
row 9999 9999
I want the leading zeros and I can't figure out what value to use in the
Text formula to get that to work. Thanks for your help.
Thanks for all the responses - the documentation on TEXT is a little sparse
and hard to find the "0000" which was what I needed.
|