Services4People

  Split columns by delimiter In Power Query, you can split a column through different methods. In this case, the column(s) selected can be split by a delimiter. Where to find Split Columns > By Delimiter You can find the  Split Columns: By Delimiter  option in three places: Home tab —under the  Split column  dropdown menu inside the  Transform  group. Transform tab —under the  Split column  dropdown menu inside the  Text column  group. Right-click a column —inside the  Split column  option. Split columns by delimiter into columns In this example, the initial table will be the one shown in the image below, with only one column for  Accounts . This column holds two values: Account number Account name In this example, you want to split this column into two columns. The values are delimited by a space—the first space from left to right. To do this split, select the column, and then select the option to split the column by a delimiter. In  Split Column by Delimiter , apply the following

  How to Record Macro in Excel It is important to know that you when you record a macro, the Macro Recorder captures almost every move you make. So if you make a mistake in your sequence, for example, clicking a button that you did not intend to click, the Macro Recorder will record it. The resolution is to re-record the entire sequence, or modify the VBA code itself. This is why whenever you record something, it's best to record a process with which you're highly familiar. The more smoothly you record a sequence, the more efficiently the macro will run when you play it back. Macros and VBA tools can be found on the  Developer  tab, which is hidden by default, so the first step is to enable it. For more information, see  Show the Developer tab . Record a macro There are a few helpful things you should know about macros: When you record a macro for performing a set of tasks in a range in Excel, the macro will only run on the cells within the range. So if you added an extra row t