LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default assign numeric value to letters and sum with other numbers

I apologize if I am duplicating an earlier question, but I can't find the
answer. How do I sum a row or column that has numbers and letters by giving
the letters a numerical equivalent?
--
WJG
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: I want to assign numeric values to letters in a speradsheet Marion Black Excel Discussion (Misc queries) 4 February 12th 13 08:00 AM
How do I assign a numeric value to a letter IASG Excel Worksheet Functions 2 November 28th 08 10:35 AM
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? ship Excel Worksheet Functions 4 April 3rd 07 02:35 PM
How do I assign a numeric value to text? IE cell = yes then 1 rrr Excel Discussion (Misc queries) 7 September 28th 06 02:01 AM
How do I assign a numeric value to a text letter Shaun Excel Discussion (Misc queries) 2 September 18th 05 12:24 AM


All times are GMT +1. The time now is 04:27 AM.

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

About Us

"It's about Microsoft Excel"