How to Use Power Query to Edit Text in Microsoft Excel
There’s more than one way to make text edits in Microsoft Excel. From changing letter case to adding a prefix, you can use Power Query to edit text in bulk. This is a great alternative to manual work or functions and formulas. How to Edit Your Text with Power Query To edit your text using Excel Power Query, you’ll follow the same steps to get started. Once you open the Power Query Editor, you can make one or more changes before transferring the data back to your spreadsheet. Select the cells containing the text you want to change, go to the Data tab, and choose From Table/Range in the Get & Transform Data section. Alternatively, you can right-click and pick Get Data From Table/Range . If your data is not already formatted as a table, you’ll be prompted to do so. Confirm the cell range in the pop-up window and optionally check the box if you have headers. Then, select OK to continue. Tip : You can revert your data back to a cell range by deleting the table in Excel l...