Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

Other versions of Excel may work differently ... we want to use to split the text string into separate columns. In this case, we will use the formula in cell K2, as shown in the screenshot at the top ...

Have you ever stared at a tangled web of paired columns in your dataset—”Size 1/Value 1,” “Size 2/Value 2,” and so on, wondering how to make sense of it all? It’s a common frustration for anyone ...