You could use this User defined Function.

If you're new to VBA, read this first:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


The function:

' ================================================== ===========================

Function StripTxt(a As String) As String

' Strips all non-numeric characters from a string, but leaves colons

' Returns a string, not a number!

Dim i As Long

Dim b As String

For i = 1 To Len(a)

b = Mid$(a, i, 1)

If ((Asc(b) 47 And Asc(b) < 58) Or b = ":") Then StripTxt = StripTxt + b

Next i

End Function

' ================================================== ===========================


--
Kind regards,

Niek Otten




"saziz" wrote in message
...

Hi,
How can I transfer from one cell to other only numerical values.
Like in one cell I have "sun rise time 06:15" I want in adjecent cell
only 06:15
Pleae help.
thanks
Saziz


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=523269