How can I assign the last 4 characters of a string to a string variable?

[dschmitt]

I have the following type of strings: (3 examples)

BMC Nephrology (2015) 16:1 Article Number: 38. Date of Publication: 1 Dec 2015
Toxicology (2015) 333 (89-99). Date of Publication: 3 Jul 2015
Clinical Chemistry and Laboratory Medicine (2015) 53 SUPPL. 1 (S1043). Date of Publication: July 2015

I want to assign the last 4 characters, which is always a year, to string variable.

How can I do this in a VBA?

[quekbc]

You can use the Right function, similar to the Excel function RIGHT.

Please Login or Register  to view this content.

Will result in "2015"

[humdingaling]

Please Login or Register  to view this content.

[dschmitt]

humdingaling, perfect! Thank you very much.