File Exchange

image thumbnail

Excel Column Conversion

version 1.0.0.0 (1.53 KB) by Ragaar Ashnod
Converts a numeric input to a column name, for Excel representation.

2 Downloads

Updated 24 May 2012

View License

EXCELCOL Converts a numeric input to a column name, for Excel representation.
OUT=ExcelCol(X) takes the input "X", which may be a number or vector
and converts it to the other representation.

EXAMPLES:
ExcelCol(254174985) % Return 'UJELLY'
ExcelCol([21 10 5 12 12 25]) % Return 'UJELLY'

Cite As

Ragaar Ashnod (2021). Excel Column Conversion (https://www.mathworks.com/matlabcentral/fileexchange/36851-excel-column-conversion), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (3)

Cosy

There is an issue for multiples of 26^n (with n=1,2,....)

Cosy

...however, after this fix there remains the issue for multiples of 26^n (where n is a natrual number)

Bruce

I experienced an error for a value of 182. ExcelCol(182)

MATLAB Release Compatibility
Created with R2008a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!