Mr. Grinder
Failed to resolve a dispute resolution thread.
- Jul 29, 2017
- 1,058
- 688
hello all excel expert , i need a little help in this big community .
as you can see there are name and some number inside the file and all are in the same colume , and i can not separate it into the two column , i need the number only like from "100000038834874"
how to separet the number and the name into the two column , like i want to set a coulm in the "|"
please help all excel expert
thanks in advance
i have a file like this in excel :
and text like this :
as you can see there are name and some number inside the file and all are in the same colume , and i can not separate it into the two column , i need the number only like from "100000038834874"
how to separet the number and the name into the two column , like i want to set a coulm in the "|"
please help all excel expert
thanks in advance
i have a file like this in excel :
and text like this :
Code:
100000848947137|Samuel Sandoval Jr.
100001835643299|David Arnold
100002298967092|Rauf A-ov
100003130005666|Paran Boruah
1533607048|Paras Poudel
100009433740427|Abu Bakar Adam
100003957030199|BiLʌl
1358417076|Febin Francis
1830624913|Shyam Kuvavala
1164846317|Terry Hargis
100020520607760|Hîkmãd ßámêh Zk
100008372317276|Karna Rk
100010499882908|Tania Dutta Singha
769253427|Mariusz Kozak
100005635305712|Lucky Präkäsh MP
758974140|Jez Newhouse
100001072221594|Oussama Oueslati
100006392616901|Prince Shoo Prince
100000261969713|Abdul Rahman
100003963928917|Mcm Unilian
100023701194080|Khan Suhaib
100009768060203|Rawi Ttezaa
100005088580786|Robert Thornton
100021760628214|Okm Anh
683135949|Pranav Kapoor
