Josh, > Would the replace function work? > replace("TEXT",VbCrLf & VbCrLf,VbCrLf) This worked perfectly - many thanks! It didn't occur to me I could concatenate within a replace function. But I do now. :) Thanks again. Charles