Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

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

user-image
Question added by Murtuza Lal Lal , Auditor , Mayur Batra Chartered
Date Posted: 2018/06/19
Tamiz Uddin Mullick
by Tamiz Uddin Mullick , Corporate Project Accountant , Swisscontact

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

More Questions Like This