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

ambi95 Have you been able to try this out?

 

Pat

ambi95's avatar
ambi95
Helper I
3 years ago

Can I ask, was there any specific reason you used Text.Upper for the input?