User Tools

Site Tools


This is an old revision of the document!

Search cells for specific text in cells and note it

  • =ISNUMBER(SEARCH(“apple”,A1))
  • 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

Split the content from one cell into two or more cells

  • 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


To get just the FIRST 3 characters of a cell :


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


To get the LAST 3 Charcters



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
excel.1561737259.txt.gz · Last modified: 2019/06/28 10:54 by zeppo