🔤 Excel Column Letter ↔ Number Converter

Convert between Excel column letters and numbers with real-time conversion

Enter 1-3 letters (A-Z only). Range: A to XFD
↔
Enter a number from 1 to 16,384

📋 Conversion Results

Column Letters: -
Column Number: -
Excel Reference: -
Position from A: -
Base-26 Value: -
Max Rows (Excel): 1,048,576

💡 Quick Examples

Column A:
A ↔ 1
First column
Column Z:
Z ↔ 26
26th column
Column AA:
AA ↔ 27
After Z
Column AB:
AB ↔ 28
28th column
Column IV:
IV ↔ 256
Excel 2003 limit
Column XFD:
XFD ↔ 16384
Excel 2007+ limit

ℹī¸ About Excel Columns

  • Base-26 System: Excel uses a modified base-26 numbering system
  • Letter Range: A-Z (26 letters) for single columns
  • Double Letters: AA-ZZ for columns 27-702
  • Triple Letters: AAA-XFD for columns 703-16,384

🔧 Excel Limits

  • Excel 2003: 256 columns (A to IV)
  • Excel 2007+: 16,384 columns (A to XFD)
  • Rows: 1,048,576 rows in modern Excel
  • Total Cells: Over 17 billion cells per worksheet

📝 Common Use Cases

  • Converting column references in formulas
  • Understanding Excel's column numbering
  • Working with VBA column indices
  • Debugging spreadsheet references
  • Learning Excel's addressing system