Main Profile

At A Glance

Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmSee Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length:1. Formula with IF, LEFT and MID Functions and the join symbol ampersand: &2. Formula with IF, LEFT and RIGHT Functions and the join symbol ampersand: &3. TEXT, REPT, LEN, LEFT, IF and REPLACE Functions and the join symbol ampersand: &4. See how to use the REPLACE Function to insert text into another test string (word or sentence in a cell)
Length: 07:29

Contact

Questions about Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers

Want more info about Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question