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

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
Helper 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