Forum Discussion
Justinyiriley
May 20, 2022Copper Contributor
Excel formula to remove a certain number of characters IF...
Hello All, I'm looking for a formula that will see if a cell begins with either "000000", "000001", or "000005", and if so, modify the text like below. If text in cell begins with 000000, then ...
Detlef_Lewin
May 20, 2022Silver Contributor
Crossposted.
=IFERROR(--B12&"","0000"&SUBSTITUTE(B12,"000000",""))