Forum Discussion

ambi95's avatar
ambi95
Helper I
3 years ago

Excel formula to power query M code

Hi all, Im trying to convert the following formula in excel to M code : =CONCATENATE(H2, MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ012345",( IFERROR(IF(FIND(MID(H2,1,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ")>0,1,...
General Comment
Need Help
Show and Tell
Tutorial Requests
ppm1's avatar
ppm1
Solution Sage
3 years ago

It looks like you are looking for the letters in your initial string. I put your formula into Excel. Can you exlpain how you get DAY suffix from that starting string (that only has two letters in it)?

 

 

Pat

  • ambi95's avatar
    ambi95
    Helper I
    3 years ago

    Hi ppm1 Apologies, I made a mistake in  my question. The original 15 digit string is a mix of letters and numbers.

    • ppm1's avatar
      ppm1
      Solution Sage
      3 years ago

      Can you give an example of an input string with the expected output? The one shown isn't clear.

       

      Pat

       

      • ambi95's avatar
        ambi95
        Helper I
        3 years ago

        ppm1 hi, here is an example of the 15 digit string - 0062o00001CG0Ob