Sub M_snb() sn = Filter(Split(Replace(Replace(Cells(1), "!", "!."), "?", "?."), "."), " ") Cells(1, 2).Resize(UBound(sn)) = Application.Transpose(sn) End Sub
Sub M_snb() sn = Filter(Split(Replace(Replace(Cells(1), "!", "!."), "?", "?."), "."), " ") Cells(1, 2).Resize(UBound(sn)) = Application.Transpose(sn) End Sub