User Tools

Site Tools


excel

Search cells for specific text in cells and note it

  • =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

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

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

IMPORTED TEXT NOT RECOGNIZED AS A DATE

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.txt · Last modified: 2018/10/25 11:46 by zeppo