Forum Discussion
Solved
MS Excel Custom Cell Formatting with Formula.
Hi Everyone! I make an excel sheet for creating Product ID and there I use formula to create the product ID. But the main thing is need to do that is the cell value format by the custom cell formatt...
Presuming data in A1, you could use:
=LET(str,TEXTSPLIT(A1,"-"),prefix,TAKE(str,,1),n,TEXT(CHOOSECOLS(str,2),"0000"),nn,TEXT(TAKE(str,,-1),"000000"),TEXTJOIN("-",,prefix,n,nn))Flash Fill has mixed results with these IDs.
Presuming data in A1, you could use:
=LET(str,TEXTSPLIT(A1,"-"),prefix,TAKE(str,,1),n,TEXT(CHOOSECOLS(str,2),"0000"),nn,TEXT(TAKE(str,,-1),"000000"),TEXTJOIN("-",,prefix,n,nn))
Flash Fill has mixed results with these IDs.