Kristopher Chance
New Member
- Joined
- Apr 3, 2014
- Messages
- 16
I would like to extract only the number from the same cell, but there is too many character in the cell, Chinese wording, decimal point, slash and other things. I have list some of sample for reference
先94235127曾生/66932742/
先電*馬小姐94848842/98281231
尹生93100051/61088053
先 91410075 陳生67371896
收貨人:楊小姐96113854/90293009
What I need is extract the number and group it together, just like
先電*馬小姐94848842/98281231 -> 9484884298281231
998293829 / 66829188 -> 99829382966829188
先 91410075 陳生67371896 -> 9141007567371896
Is that possible?
先94235127曾生/66932742/
先電*馬小姐94848842/98281231
尹生93100051/61088053
先 91410075 陳生67371896
收貨人:楊小姐96113854/90293009
What I need is extract the number and group it together, just like
先電*馬小姐94848842/98281231 -> 9484884298281231
998293829 / 66829188 -> 99829382966829188
先 91410075 陳生67371896 -> 9141007567371896
Is that possible?