Clean up the Google Excel spreadsheet and leave only phone numbers really?

Question

Google Sheets

For several days now, having nothing to do with tables, I want to get phone numbers from a Google table.
They are in this format:
05/07/17, 21:40:46: [phone]: ‎In attesa del messaggio. Potrebbe volerci un po' di tempo.
05/07/17, 21:41:21: [phone]: Hey
05/07/17, 21:41:21: [phone]: Hey
05/07/17, 21:41: 29: ✪ DEUS ✪: Hei
05/07/17, 21:41:33: [phone]: Hay✌
05/07/17, 21:41:36: [phone]: wg euch so
05/07/17, 21:41:55: [phone]: Gut und euch
05/07/17, 21:42:20: [phone]: scheiße euch
05/07/17, 21 :42:26: [phone]: es geht
05/07/17, 21:42:28: [phone]: Was los
07/05/17, 21:42:33: [phone]: Ihr könnt auch noch mehr schicken wenn ihr wollt mit ost es egal
which modules or functions need to be driven in so that only numbers remain without pluses and without spaces, stupid column. "[phone]" I will be grateful to everyone [phone]
[phone] p.s. the numbers are all different, different countries, I then manually drive them into icloud.

Answer 1

As an option, use visual basic
vdasus.com/2011/11/03/regularnye-vyrazheniya-v-excel

Answer 2

copy the column with the phones, then paste it into an empty .txt document
after, if necessary, you can "correct" it using regular expressions. Let's say we get lines like
05/07/17 , 21:42:28: [phone]: Was los [phone]: Was los search and delete from the beginning of the line up to + inclusive and from the end of the line up to : inclusive profit

Answer 3

1. split by columns https://i.imgur.com/tDcAs5S.png
   Get a clean speaker with phones.