Thursday, February 27, 2020

Use PowerQuery to Change the Order of Cell Values or Text


If you've tried to rearrange the order of text or data in cells within Excel, you're probably familiar with the LEFT, MID and RIGHT functions. The combination of these functions help you reverse text or first and last names. You can rearrange the data of almost any kind of content in your cells with these function. Incidentally there are formulas in the Power Query M code that can do the same thing and this video will cover two examples.

2 comments:

  1. High Technologies Solutions Provide Advanced Excel, MIS, VBA, SQL, C, C++, JAVA Training with 100% Placement assistance. Further More Info here-+91-9311002620.

    Advanced Excel Training Institute in Delhi
    Advanced Excel Training Institute in Noida

    ReplyDelete