Forum Discussion

athegn's avatar
athegn
Copper Contributor
Dec 21, 2023

Add OR function to a formula

I am given a phrase like this:-   "Circular walk from High Ongar to Fyfield Meet: High Ongar Church. park along road."   =MID(PDF!$B4,FIND("Meet: ",PDF!$B4)+6,FIND(CHAR(46),PDF!$B4,FIND("Meet: "...
excel
microsoft 365
peiyezhu's avatar
peiyezhu
Bronze Contributor
Dec 22, 2023

based on
Circular walk from High Ongar to Fyfield
Meet: High Ongar Church. park along road.

what is your expected result string?

  • athegn's avatar
    athegn
    Copper Contributor
    Dec 22, 2023
    High Ongar Church i.e the same as when a period is there but a comma in its place.
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Dec 22, 2023
      OK.
      Have you tried the webservice formular I provided if your original string in range A2?
      • athegn's avatar
        athegn
        Copper Contributor
        Dec 23, 2023
        I have tried but Chrome will not let me access; claims it is unsecure.

Resources