Is there a way to extract only the numbers within a string?

Maei

I need to extract the numbers only within this column.

=Chris Palmer

Hi @Maei,

You can explore with something like this:

=IFERROR(IF(AND(VALUE(LEFT(ColumnName@row, 2)) > 0), LEFT(ColumnName@row, 2)), IFERROR(IF(AND(VALUE(LEFT(ColumnName@row, 1)) > 0, ISTEXT(MID(ColumnName@row, 2, 1))), VALUE(LEFT(ColumnName@row, 1)), ""), ""))

Replace "ColumnName" with the name of your column.

Hope this helps!