Chris C #1 probably need Data = Replace(Data, "~~n", Chr(10))to escape the ~you were replacing chr 10 with chr 10