![photo](/responsive_image/150/150/0/0/0/cache/matlabcentral/profiles/8747872_1528058504302_DEF.jpg)
Praveen Bulusu
Followers: 0 Following: 0
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년 초과 전 | 다운로드 수: 2 |
답변 있음
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...
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...
4년 초과 전 | 4