Jan 27 2022 03:58 PM
I am trying to use the concat formula to bring together 3 cells, but also build a range for a list. For example,
418 | 263 | 8902 | 9501 |
and create the list to produce
4182638902
4182638903
4182638904 and so on
Jan 27 2022 04:11 PM
=($A$1&$B$1)*10000+SEQUENCE(D1-C1+1,,C1)