Removing ".", "?" or "!" from last word of sentence and replacing it later in vba.

Hi,

I have a routine that takes a sentence and uses Split to separate the words for processing.

It works fine, except for the last word, because this will have a period or whatever, and so a word look-up will fail.

I need to get the last word, remove the period (and remember it).

Then I need to process all the words (that part works fine), and put the ending back.

Whatever I try I gt syntax errors when I try to address the last element (last word) in the Split array to alter the word.

Any help would be much appreciated.

Can you post a workbook, or at least the code you're using?

Works better if you close off your brackets

Please Login or Register  to view this content.

That worked, HSV. Thanks.