------------------------------------------------------------- Private Function Chg_Fid_Str(Str As Variant) As String '============================================ ' 読点と改行をカンマに変換する '============================================ Dim wkAry() As String, i As Long, wkStr As String
wkStr = "" For i = 0 To UBound(wkAry) If Trim(wkAry(i)) <> "" Then If wkStr <> "" Then wkStr = wkStr & "," wkAry(i) = Trim(wkAry(i)) If AscB(Mid(wkAry(i), Len(wkAry(i)), 1)) = 160 Then wkAry(i) = Left(wkAry(i), Len(wkAry(i)) - 1) ' ← ココ wkStr = wkStr & wkAry(i) End If Next
End If
Chg_Fid_Str = wkStr
End Function -------------------------------------------------------------