Forum Discussion
Automatically 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
=CONCATENATE(LEFT(A1,3),"-",MID(A1,4,4),"-",RIGHT(A1,4))
Instead of copy/paste you can try this formula.
Thanks, that worked.