I'm trying to extract values from the text (column A) into three columns with array formula in each column:
- Name (column C)
Text with numbers, dots and special symbols (like ',&,’) written together. - First standalone number (column D)
It can have dots written together. - Second standalone number (column E)
It can have dots written together. - Sign (column F)
Just symbols and -.
But now I can't get the expected results (column C:F). I've texted my formulas in H:K range, but they are bad. Is it even possible to solve it with array formulas and regexreplace?
I will be grateful for advice!