you can also use the Chr function as in Chr(13) to search for hard line feeds and pillcrows. Its especially useful for cells in tables which have a hardline feed that isn't a hard line feed. I discovered this while pulling text in and out of a table and it kept adding extra lines