{"id":5947,"date":"2021-03-12T17:14:19","date_gmt":"2021-03-12T16:14:19","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5947"},"modified":"2024-03-22T18:45:31","modified_gmt":"2024-03-22T17:45:31","slug":"replicating-excels-right-function-with-m-in-power-query","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/replicating-excels-right-function-with-m-in-power-query\/","title":{"rendered":"Replicating Excel’s RIGHT Function with M in Power Query"},"content":{"rendered":"

\"Replicating<\/a><\/p>\n

Power Query<\/a><\/strong> lets you perform a series of steps to transform your Excel data. There are times when we want to do things that are not built into the user interface.<\/p>\n

This is possible with Power Query’s programming language<\/a>, which is M.<\/strong><\/p>\n

Unfortunately, not all of Excel’s formulas<\/a> can be used in M.<\/p>\n

For example, if we want to use the Excel RIGHT Func<\/strong>tion<\/strong>,<\/strong> it is not supported in\u00a0M<\/strong>.<\/p>\n

But I will show you how we can replicate\u00a0the\u00a0RIGHT Function Power Query <\/strong>in M and the Text.End<\/strong> formula<\/a>!<\/p>\n

If you want to learn how to get started with M, click here<\/a>.<\/p>\n

In this example, you can see there is a column I mentioning quarter. You want to extract the last character from the text. QTR1 mentioned in cell I2, you want to extract the number<\/a> 1.<\/p>\n

You can use the Text.End function in Excel PowerQuery to\u00a0returns the number of characters from the end of a text value.<\/p>\n

\"Replicating<\/a><\/p>\n

 <\/p>\n

Syntax of Text.End Function<\/span><\/h3>\n

The syntax of Text.End Function is:<\/p>\n

=TEXT.END(text, num_chars)<\/h3>\n

where:<\/p>\n