Hi Austen,

This doesn't use the Split function, which splits up a line of text based on a delimiter, but should be what you're looking for:[vba] Dim tempStr As String, str1 As String, str2 As String
tempStr = Range("A1").Text 'cell containing long string
str1 = Left(tempStr, 3752)
str2 = Mid(tempStr, 3753)[/vba]Matt