how to replace last comma in string with "and"

String example: "cats, dogs, birds, chickens, cows"
I am looking for a VBA script that replaces the last comma in that string:
Output string: "cats, dogs, birds, chickens and cows"

Assume that the number of characters before and after the last comma changes from string to string.
Also the number of commas before the last comma changes from string to string.

How can I script that?

thanks. With some trial and error I was able to convert it to the VBA script.

Please Login or Register  to view this content.