Excel Function Question

CFA General
#1

What function can turn a string into a number value? A=65

#2

Not sure what you mean. like =LEN(), when if a1 = Poorly Written Question, =LEN(a1) would return 23?

#3

if I was looking for the number of characters why would A=65? Is there a function to convert a letter/string to its ASCII value

#4

=+CODE(“A”)

#5

ok I guess I can use code() for the first character and mid() to cycle through the rest - thanks adeh