latkaheadCopper ContributorDec 23, 2022Automatically reformat an alphanumeric text string The value D3000023405 is in cell A1. When I copy/paste A1 into cell B1, I want it to be automatically be reformatted like this: D30-0002-3405 How? Thanks Show More
JerryDNYCCopper ContributorDec 24, 2022latkahead If you have 365, you could use:="D30-"&TEXT(SEQUENCE(100),"000#")&"-3405"Adapt as needed.
