The challenge is that Excel can handle over 16,000 columns, so the number of letter combinations is large.
This is the approach explained below.
One way to do this is with theSUBSTITUTE function.
The result from this formula is the same as above, but the configuration is a bit simpler.
For example, =ADDRESS(1,1) returns $A$1.
SUBSTITUTE Function
The Excel SUBSTITUTE function replaces text in a given string by matching.
