Forum Discussion

arise2read's avatar
arise2read
Copper Contributor
May 21, 2020

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...
Excel on Mac
Jos_Woolley's avatar
Jos_Woolley
Iron Contributor
May 21, 2020

arise2read 

 

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 22, 2020

Jos_Woolley 

To be more safe, it's better 20/19 to replace on #20/19 as well

  • Jos_Woolley's avatar
    Jos_Woolley
    Iron Contributor
    May 22, 2020
    Can you give an example for which your suggestion would make a difference?

    Regards
      • Jos_Woolley's avatar
        Jos_Woolley
        Iron Contributor
        May 22, 2020

        SergeiBaklan 

         

        Ah, I see. I discounted such possibilities since I presumed from the OP's original post that all dates had a year beginning 20**. Though I may be wrong, in which case you are correct.

         

        Regards

Resources