Òyì nke e mepụtara

We have names and phone numbers given in one column and we want to extract names to the name column and phone number numbers to phone number column. Instead of doing it manually we will do it with a trick. Select all the data press Ctrl plus G and here select constant and unchecked all others, checked only number and hit okay. All the numbers will be selected copy it and paste it to phon number column. Repeat the same for names too. Uncheck all except the text. Copy it and paste in name column.