Learn
Using the CONCAT function Follow these steps: Continue with the workbook from the previous section; that is, SSGJoin.xlsx. We will use the ...
Sorting out empty rows In the workbook named BlankCells.xlsx, we have several blank rows in the dataset. To remove all the blank rows from the ...
Using the UNIQUE function The UNIQUE function is a new function for the latest version of Excel. It is a dynamic function that updates data ...
Removing spaces or hidden characters There are several ways to remove spaces from workbook data once it's been imported. We can use the TRIM and ...
Removing duplicate data To locate duplicates in a worksheet, follow these steps: First, open the workbook named Duplicates.xlsx. Always make ...
Importing, cleaning, joining, and separating data When we import data from different sources, cell data may contain extra spaces or invisible ...
Setting up a conditional formatting rule Now that we have the rule in place, we would like to ensure that every time a user selects an item from ...
Conditional formatting functions Conditional formatting is a format, such as a cell shading or font color, that's automatically applied to cells ...
Extracting using wildcard characters Wildcard operators are useful for extracting data according to a partial match within a cell. For instance, ...
Using operators to refine filters We can further broaden our filters using comparison operators. Previously in this book, we concentrated on the ...
