Function SubstrInterpoint(ByVal src As String) As String SubstrInterpoint = Substr(s, "・", Chr(10)) End Function Function Substr(ByVal src As String, ByVal startChar As String, ByVal endChar As String) As String If (src = "") Then Substr = "" Else startIndex = InStr(1, src, startChar, 1) If (startIndex < 1) Then Substr = "" Else endIndex = InStr(startIndex + 1, src, endChar, 1) - 1 If (endIndex < startIndex) Then endIndex = Len(src) End If Substr = Mid(src, startIndex, endIndex - startIndex + 1) End If End If End Function