Here is a very simple, basic UDF
Function ContactDetails(rng As Range)
Dim aryDetails(1 To 3) As String
Dim cell As Range
Set cell = rng.Find("e-mail")
If Not cell Is Nothing Then
aryDetails(1) = LTrim$(Replace(cell.Value, "E-mail:", ""))
End If
Set cell = rng.Find("telephone")
If Not cell Is Nothing Then
aryDetails(2) = LTrim$(Replace(cell.Value, "Telephone:", ""))
End If
Set cell = rng.Find("fax")
If Not cell Is Nothing Then
aryDetails(3) = LTrim$(Replace(cell.Value, "Fax:", ""))
End If
ContactDetails = aryDetails
End Function
To use it select all three cells, say M2:O2, and enter =ContactDetails(A2:I2), and array-enter it (Ctrl-Shift-Enter), and that should do it.