Forum Discussion
Power Query formula to trim text length to 100 characters
Hi there I created a custom column called [Name] in Excel Power Query, which is a concatenation of 2 fields - [Project ID] +[Project Name]. I have to upload this data for 20K+ records into a CRM sy...
Select column in Power Query editor -> Transform -> Extract -> First Characters -> 100
Actually it uses Text.Start() function