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 system, however this CRM only takes max 100 characters for the field.

What is the Power Query formula to trim the new column [Name] so that it does not exceed 100 characters (otherwise the CRM system will create an error for that record).

Thanks!
Aisha