Dueling Excel 107


Count Between Words

DESCRIPTION

See 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)

WORKBOOKS