View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Igneshwara reddy[_2_] Igneshwara reddy[_2_] is offline
external usenet poster
 
Posts: 68
Default 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 "&".