photo

Praveen Bulusu


Last seen: 11ヶ月 前 |  2020 年からアクティブ

Followers: 0   Following: 0

統計

All
  • First Submission
  • First Answer

バッジを表示

Feeds

表示方法

送信済み


MS Excel column from number and vice versa
Get column id from number. For example 26-'z', 702-'zz',703-'AAA', etc.. Likewise, get column number from text.

4年以上 前 | ダウンロード 1 件 |

回答済み
I need to convert a number into its column name equivalent
You can use the following functions. It works for any number. num=14558 a=num2xlcol(num) % convert number to xlcol b=xlc...

5年弱 前 | 4