1 / 10

TEXT AND DATE FORMULAS

TEXT AND DATE FORMULAS. MID, CONCANTENATE, FIND, SUBTITUTE, LOWER, UPPER, DATE, NOW. TEXT FORMULAS. MID Return the characters from a middle text of strings FORMULA : MID(TEXT,START_POS,TOTAL_CHAR) Example: MID(“Bummi Dwi Putera”,1,9) // Bummi Dwi. CONCATENATE

raymond-osborne
Download Presentation

TEXT AND DATE FORMULAS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TEXT AND DATE FORMULAS MID, CONCANTENATE, FIND, SUBTITUTE, LOWER, UPPER, DATE, NOW

  2. TEXT FORMULAS MID Return the characters from a middle text of strings FORMULA : MID(TEXT,START_POS,TOTAL_CHAR) Example: MID(“Bummi Dwi Putera”,1,9) // Bummi Dwi

  3. CONCATENATE Joining The String/Text/Char FORMULAS CONCATENATE(TEXT,OTHER_TEXT,N_TEXT) Example CONCATENATE (“BUM”,”M”,”I”) //BUMMI

  4. FIND Return position of Character found on the Strings FORMULAS FIND(FIND_TEXT,WITHIN_TEXT,START_NUM) Example FIND(“DWI”,”BUMMI DWI”,1) // 7

  5. SUBTITUTE Replace existing text with new text within a strings FORMULAS SUBTITUTE(TEXT,OLD_TEXT,NEW_TEXT) Example SUBTITUTE(“BUMI”,”MI”,”MMI”) //BUMMI

  6. LOWER and UPPER CASE Convert STRINGS To Lower / Upper Case FORMULAS LOWER(STRINGS) UPPER(STRINGS) Example LOWER(“APA AJA dah”) // apa aja dah UPPER(“apa AJA Dah”) // APA AJA DAH

  7. DATE FORMULAS DATE and NOW Return value of date format FORMULAS DATE(year,month,day) NOW() Example DATE(2012,03,04) // 2012/03/04 NOW() // 3/24/2012 2:43

  8. Raw Data Table

  9. Format Report

  10. TEXT PROCESSING IN EXCEL If We use, same formula This Error show up for this section, it because The String just have one word

More Related