Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.
In the screenshot below, when the first and last initials of the names in columns A and B are typed into cells C2, C3, and C4 ...