How to extract text from a string?

D

Danil2021-05-04 01:26:35

excel

Danil, 2021-05-04 01:26:35

Good afternoon!
There is a cell in it text

color / size: white / 98 - 559 Rub.; color/size: white/ 104 - 559 RUB; color / size: white / 110 - 559 rubles; color / size: white / 116 - 559 rubles; color / size: white / 122 - 559 RUB.

I need a formula, yes anything, to extract the selected data. Ideally, add "cm" to each one.
To get 98 cm, 104 cm, 110 cm, etc.

What formula can do this?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Ivanov, 2021-05-04
@Nikop

In Tables, it is often used REPTto generate an expressionREGEXEXTRACT

=INDEX(JOIN(",";
  REGEXEXTRACT(
    B2;
    REPT(".*/(\d+)";COUNTA(SPLIT(B2;"Руб";0))-1)
  ) & "см"
))