Formula question in Excel

Question

excel

What formula, or combination of formulas, can be used so that only the numbers from column A fit into column B?

gyazo.com/86ec9bef0f73a4eb6a89d701b876732e

* Now there are just numbers for example

Answer 1

office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx

Answer 2

1. Copy the column
2. Select it, right-click, and in the "cell format" section, select the desired one, what to display and how. Xs how it is in excel, I have an open office.
Ps They don't like questions about Excel here. last time my karma was drained to minus 7 for an excel question that I asked)

Answer 3

Probably, it is necessary to do by replacing characters with "". This is from Google's Q&A.
для цифр:
=значен(заменить(текст(ячейка_в_которой_нужно_заменить_цифры);начальная_позиция;количество_символов;числа_которые_нужно_вставить))
для текста:
=заменить(ячейка_в_которой_нужно_заменить_буквы;начальная_позиция;количество_символов;буквы_которые_нужно_вставить)