Hello AsaThis =FIND(UPPER(A1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ")and this is ok =CODE(UPPER(A1))-64for under result a =1 b= 2 c=3 but what about for this acb =132 Regards LAKSHMAN
________________________________ From: Asa Rossoff <a...@lovetour.info> To: excel-macros@googlegroups.com Sent: Tuesday, 27 December 2011 8:37 AM Subject: RE: $$Excel-Macros$$ Need help Hi Rekha, Here's one method. It will return 1-26 for A-Z, whether upper or lower case. If any other character, it will give an error: =FIND(UPPER(A1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ") Here's another method, it will return a number for any character. If the charcater is A-Z (upper or lower case), it will be 1-26, otherwise it will be a negative number or a number higher than 26: =CODE(UPPER(A1))-64 Although the above could be modified to return an error for other characters, if that's important, the FIND() method is probably simpler and faster. Asa From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rekha siri Sent: Monday, December 26, 2011 2:01 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help hi experts, please advise the formula to convert the alphabets to numbers. for example a =1 b= 2 c=3 acb =132 like this for each alphabet it should convert text to number. Thanks for your help Regards, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com-- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
