You could also click on format cell create a custom text field and have the \\AU-D0 complete for you. Then in the next cell just have \D$

Then Copy paste it to notepad and delete the space between \\AU-D01234 \D$ and bang

I used to do that heaps.