Excel Column Number To Column Name

Version 1.4.0.0 (1.76 KB) by Matt G
Converts an array of numbers to a cell array of Excel column names
4.1K Downloads
Updated 3 Aug 2009

View License

XLSCOLNUM2STR takes in an array of numbers and returns a cellular array of the same size with cell of corresponding Excel column names.

example:
n=[1 10;
53 256]
c=xlsColNum2Str(n);
c={'A' , 'J';
'BA', 'IV'}

See Also XLSCOLSTR2NUM

Cite As

Matt G (2026). Excel Column Number To Column Name (https://www.mathworks.com/matlabcentral/fileexchange/15748-excel-column-number-to-column-name), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2006b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Version Published Release Notes
1.4.0.0

Updated summary

1.3.0.0

Fixed bug noted by Malcolm Lidierth.

1.0.0.0

Changed category, added screenshot