OK, so I need a hand with the following, if anyone can help it would be appreciated!

I have around 30,000 lines of data; an example of a few lines shown below

Limited Edition 1916 - Womens T-Shirt - Small - Azalea - 100th Birthday
Limited Edition 1916 - Womens T-Shirt - Medium - Azalea - 100th Birthday
Limited Edition 1916 - Womens T-Shirt - Large - Azalea - 100th Birthday
Limited Edition 1917 - Womens T-Shirt - Small - Azalea - 99th Birthday
Limited Edition 1917 - Womens T-Shirt - Medium - Azalea - 99th Birthday
Limited Edition 1917 - Womens T-Shirt - Large - Azalea - 99th Birthday
Limited Edition 1918 - Womens T-Shirt - Small - Azalea - 98th Birthday
Limited Edition 1918 - Womens T-Shirt - Medium - Azalea - 98th Birthday
Limited Edition 1918 - Womens T-Shirt - Large - Azalea - 98th Birthday

etc etc etc

all the way down to Limited Edition 2000 - Womens T-Shirt - Large - Azalea - 16th Birthday

What I need to do is replace all the 100th Birthday's with 101st Birthday and all the 99th Birthday's with 100 Birthday, 98th's with 99th all the way down to zero without having to do a Find / Replace 100 times! Not sure if I'm just being dumb or if it requires some kind of VBA to do. I would normally use text to columns for this kind of thing and replace the - 100th Birthday with | 100th Birthday to put it into a unique cell but the data isn't consistent all the way down so will need to do a Find and replace someway (I think!)

Any help would be appreciated..!