View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lehainam[_27_] lehainam[_27_] is offline
external usenet poster
 
Posts: 1
Default Extract Only Number From A String


Dear all,

In Excel, is there any function that I can get number only in string
that has number & text

Ex: in cell A1 589as56
I would like to get the string 58956 only

Thank you very much

Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=545735