- Hot Topics
Excel Extract only number from same cell
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?
This question generated 36 answers. To proceed to the answers, click here.
This thread is current as of April 3, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel