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
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.
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Dec 23, 2023

      athegn 

      How did you access with Chrome?

      Can you show your screenshot?

       

       

      This is an Excel formula which need 
      enter in cell B2.

       

      I access below url with Chrome on mobile

      https://e.anyoupin.cn/EData/?

       

       

      • athegn's avatar
        athegn
        Copper Contributor
        Dec 24, 2023

        peiyezhu 

         

        Thank you for your reply.

        I can now access //e.anyoupin.cn/EData/ I assumme I need to look at item 1134 or 1133.

        I cannot see a formula in either. Where is the forumla please?

        screen shot link attached:-

         

        https://1drv.ms/i/s!AjOlZpcBKY49jKJx21JhQt5FWIRfwA?e=lgTArm

Resources