Forum Discussion

ambi95's avatar
ambi95
Icon for Helper I rankHelper 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
Icon for Solution Sage rankSolution Sage
3 years ago

I'm sure this can be done in the Power Query editor with Text.Split and list functions, but can you explain your logic? Also, your example value has only 13 characters.

 

Pat

  • ambi95's avatar
    ambi95
    Icon for Helper I rankHelper I
    3 years ago

    ppm thanks for the suggestion, could you tell me how ad where to start ?

    basically the logic is that we want to convert a 15 digit code to another 18 digit code - using that formula above