TEXTSPLIT has six arguments, but only two are required. Let’s focus on those two. The first argument is “Text,” which is the text string ... the customer’s address in cell L2, the formula is grayed ...
Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number. This can be hard-coded inside double quotes or a reference to a cell ...