separating numbers from a alphanumeric cell
How to separate numbers from a alphanumeri cell.
For Eg: If a cell contains data as 1. Apple25orange50
The result should come as 25&50.
Eg: 2 . sdfldsj2535hlkfd2548dsfs36 - result should be as 2535&2548&36
There should be separator with "&" function.
Can any one guide me with the formula to use with "&" and without "&".
|