I've got following strings inside Google Sheets:

Any solution to convert it to calculating function from this - so it gives the value - within same field or seperate?

CodePudding user response：

try:

=INDEX(QUERY(; "select "&A6); 2)