Home > OS >  Complex REGEXREPLACE with dots and special symbols in Google Sheets
Complex REGEXREPLACE with dots and special symbols in Google Sheets

Time:01-05

I'm trying to extract values from the text (column A) into three columns with array formula in each column:

  1. Name (column C)
    Text with numbers, dots and special symbols (like ',&,’) written together.
  2. First standalone number (column D)
    It can have dots written together.
  3. Second standalone number (column E)
    It can have dots written together.
  4. 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!

Example
enter image description here

  • Related