Forum Discussion
Formula to add a 0 in front of numbers<10 with multiple decimals
Hi, I'm trying to create a formula that will turn a cell such as "3.5.12.5 Introduction" into "03.05.12.05" for a Table of Contents solution. The formula I have functions properly before the f...
Hi John, I have a formula here for Excel 365 or Excel for the Web. Unfortunately, it doesn't work so easily with older versions. I have used TEXTSPLIT().
=TEXTJOIN(".",TRUE,IF(ISNUMBER(TEXTSPLIT(B5,{".";" "})+0),TEXT(TEXTSPLIT(B5,{".";" "}),"00"),""))