Thanks for your response. I'm hoping this will not be a black hole project.
With the dollar sign my understanding of the function "IsNumeric" is that a dollar value is still recognised as TRUE...
The solution for stopping the punctuation filter from joining words was quite simple. I changed replace with nothing to replace with a space.
However this did not work for the full stop line - the result appears with a space in the same row. Eg joined.word became "joined word" on one row rather than "joined" and "word". I assume this is something todoing with the lack of a split function but I could not figure out how to fix it.
Bookmarks