I am looking for an excel formula to convert ("CAMBRIDGE") to number (123456789)?

Question

I need this to create a product pricing with alpha code.

Tamiz Uddin Mullick · Answer

you can use following code in VBA to generate ASCII code using the function "ConvertToNumeric([replace with cell reference])".

--- paste below mentioned code in VBA/Macro editor ---

Function ConvertToNumeric(myText As String)Dim c As CharactersDim endResult As StringendResult = ""For i = 1 To Len(myText) endResult = endResult & Asc(Mid(myText, i, 1))Next iConvertToNumeric = endResultEnd Function

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

I am looking for an excel formula to convert ("CAMBRIDGE") to number (123456789)?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة