Code covered by the BSD License  

Highlights from
abc2num

Be the first to rate this file! 2 Downloads (last 30 days) File Size: 2.1 KB File ID: #14008
image thumbnail

abc2num

by DS

 

19 Feb 2007 (Updated 03 Aug 2007)

Function that translates a spreadsheet column label to a column number.

| Watch this File

File Information
Description

ABC2NUM(S), where S is a one or two letter string representing a column label commonly employed by spreadsheet programs, returns a number corresponding to the spreadsheet column indicated by S.
 

 Example:
       S = 'CS';
       abc2num(S);

       ans =
           97

MATLAB release MATLAB 7.0.4 (R14SP2)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Please login to add a comment or rating.
Updates
20 Jun 2007

Included acknowledgment of the complementary function NUM2ABC.

03 Aug 2007

Fixed m-lint warnings.

Tag Activity for this File
Tag Applied By Date/Time
data import DS 22 Oct 2008 09:01:07
data export DS 22 Oct 2008 09:01:07
excel DS 22 Oct 2008 09:01:07
spreadsheet DS 22 Oct 2008 09:01:07
label DS 22 Oct 2008 09:01:07
string conversion DS 22 Oct 2008 09:01:07

Contact us at files@mathworks.com