Remember Me?

#### Menu

#1
May 18th 07, 09:50 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2007 Posts: 1
How do I convert letters to numbers in Excel?

I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

#2
May 18th 07, 09:57 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 108
How do I convert letters to numbers in Excel?

On 18 May, 21:50, scarly123
wrote:
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

Hi scarly123

If A is in A1 then in B1 type

=CODE(A1)-65

Regards

Steve

#3
May 18th 07, 09:59 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 947
How do I convert letters to numbers in Excel?

A=0

Hi. Note that the Asc Code for the letter A is =CODE("A"), or 65.
If A1 has the letter "A", then one way...
=CODE(A1)-65
...e.tc.
--
HTH :)
Dana DeLouis
Windows XP & Excel 2007

"scarly123" wrote in message
...
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

#4
May 18th 07, 11:43 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,909
How do I convert letters to numbers in Excel?

All 26 letters or just some letters?

".........and on" is not too detailed.

Do you need this for a grade-point system or similar?

Gord Dibben MS Excel MVP

On Fri, 18 May 2007 13:50:00 -0700, scarly123
wrote:

I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

#5
May 19th 07, 12:55 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 698
How do I convert letters to numbers in Excel?

Perhaps you can play with this to do what you want. Enter a in A1 and it
returns 5.

=LOOKUP(A1,{"a","b","c","d","e"},{5,4,3,2,1})

HTH
Regards,
Howard

"scarly123" wrote in message
...
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

#6
May 19th 07, 01:01 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856
How do I convert letters to numbers in Excel?

Probably more robust to have:

=CODE(UPPER(A1))-65

Hope this helps.

Pete

On May 18, 9:57 pm, Scoops wrote:
On 18 May, 21:50, scarly123
wrote:

I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

Hi scarly123

If A is in A1 then in B1 type

=CODE(A1)-65

Regards

Steve

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ship Excel Worksheet Functions 4 April 3rd 07 02:35 PM Gerardo Granados Excel Discussion (Misc queries) 6 November 13th 06 02:48 PM g75 Charts and Charting in Excel 9 February 3rd 06 04:33 PM Rhapsody 1234 Excel Worksheet Functions 8 December 9th 05 07:33 PM jplazola Excel Discussion (Misc queries) 4 June 29th 05 09:29 AM

All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017