Main Profile

At A Glance

Excel Magic Trick 927: Insert Zero For Alphanumeric String With Single Digit Numbers

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmSee how to:1. See how to use IF , LEN and REPLACE Function to insert a zero for numbers that have a single digit. Example LTR1 changes to LTR01, but LTR12 stays as LTR12.
Length: 02:52

Contact

Questions about Excel Magic Trick 927: Insert Zero For Alphanumeric String With Single Digit Numbers

Want more info about Excel Magic Trick 927: Insert Zero For Alphanumeric String With Single Digit Numbers? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question