• =ISNUMBER(SEARCH(“apple”,A1))
• =ISNUMBER(SEARCH(C4,B4))
• Where the text you are looking for is in cell C4 and the cell to be searched is B4

Merge (and UN- Merge) Cells with Data

Conditional Formatting (Colors) and using "Absoloute Reference" in cell formula and Conditional Formulas

Text AND Formula in the same cell

Date and Time Functions

Dealing with Duplicate

• Select the cell or cells whose contents you want to split. …
• On the Data tab, in the Data Tools group, click Text to Columns. …
• Choose Delimited if it is not already selected, and then click Next

https://support.office.com/en-us/article/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23

To get just the FIRST 3 characters of a cell :

=LEFT(A1,3)

To get everything AFTER the first 3 characters of a cell :

=IFERROR(RIGHT(A1,LEN(A1)-3),“”)

To get the LAST 3 Charcters

=RIGHT(A1,3)

https://stackoverflow.com/questions/49850210/excel-formula-to-split-cell-text-based-on-char-count

The steps :

1. Select only the column of “dates”
2. Click Data > Text to Columns
3. Click Next
4. Click Next
5. In step 3 of the wizard, check “Date” under Col data format, then choose: “DMY” from the droplist.
6. Click Finish

https://www.techonthenet.com/excel/questions/remove_scientific.php

REMOVE DUPLICATES FROM A COLUMN IN EXCEL

Select the range of cells that has duplicate values you want to remove.

Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.

Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.