Convert text to numbers
TEXT function
VLOOKUP function
SUMIF function
All functions
Drop-down lists and data validation
You can always ask an expert in the Excel Tech Community or get support in Communities.