### 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