Quote:
Originally Posted by ImAhNoBoDy
As I was searching for another solution, I ended up on a site that creates excel formulas using AI. It came up with this and it works:
Code:
=TEXTJOIN(",",TRUE,ADDRESS(ROW(A1:E1),COLUMN(A1:E1)))
|
Excellent. One of those too few occasions when AI produces a sensible result. Could you provide a link to that site please?
ps, you could use 4 as the ADDRESS function's 3rd argument to lose the $ symbols too.