Forum Discussion
Find and Replace Partial numbers
I realize this is a simple problem, but after spending a ridiculous amount of time reading and researching, I can't figure it out! I have a very long list of birthdates that, when uploaded, were ch...
Hi,
Simple with a formula, but not so simple using Find & Replace! I can do it with 3 consecutive Find & Replaces, though no less than that:
Find what: 20/20
Replace with: #20/20
Find what: /20
Replace with: /19
Find what: #20
Replace with: 20
If that's not to your liking, perhaps a formula-based approach is an option for you?
Cheers