Register now or log in to join your professional community.
I need this to create a product pricing with alpha code.
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