Cleaning WhatsApp data. Attached the file with name "Test-Checking". Contains mobile number from different continents(See different tabs in excel). Need a format mention below.
usa& canada: +1 123 456 7890
uk:+44 7911 123456
oceania:+61 A BBBB BBBB
asia:+98 xxx xxx xxxx
europe:+49 xx xxxx xxxx
Middle East:+971 xxxx xxxx
Africa:+27 11 978 5313
Where alphabets represents any number from 0 to 9
Bookmarks