Your contact list will be listed here on a single row this open an Import Data dialogue box where you would see $A$1 indicating that your data will be placed starting fron cell A1: An In the Text Import Wizard step 3, Click > Finish this places lines in your data to separate each contactĦ. In the Text Import Wizard step 2, choose ‘Comma’ as the delimiter that your data contains then >Next In the Text Import Wizard step 1, choose ‘Delimited’ as the file type that describes your data then >Nextĥ. txt file (in step 1) is stored and ImportĤ. Open a new excel sheet, Click on DATA > From Text (under ‘Get External Data’)ģ. To avoid pasting the list in a single cell, follow these guidelines:ġ. Since we are using the web portal for WhatsApp, this workaround is applicable for both Android and iPhone users. However, there is no need to use any third party app to export WhatsApp Group contacts. This workaround is pretty simple and you need a bit idea about the Dev Tool available with the browser. Now you have all contacts list in the excel file. It will sort the column in a way that all the number will come one by one and then after all the names (from contacts).
Now you can see the data is in a single column.ĭo the sorting of data by clicking on sort and filter (Select the tool from Ribbon bar right on top in editing section). Instead of pasting the data directly, use the excel paste special function and select Transpose. Now select a single cell to paste again that data. So what you need to do is to select and copy the row records again. Paste the Data to ExcelĪfter pasting the data into excel, you will see that the data is pasted in a row rather than column. Now Copy all the data and paste it to excel application. Now you will get all unsaved contacts in proper mobile number format.
0 kommentar(er)
