I have excel sheet with around 2000 entry that I need to change them all at once.
Eace row begins with
AC-DF-01
AC-SW-02
AC-JK-04
AC-QQ-05
AC-DF-06
AC-VW-07
I need to rearrange the coding of these entry to make the digits before the middle letter: AC-01-DF instead of AC-DF-01
Is there any code in VB or excel can do it for me automatically?
Thanks
Bookmarks