I am trying to use a shortcuts of all my files from sub folders into the main folder as a directory . Obviously when you create shortcuts, microsoft automatically puts a prefix of 'shortcut' prior to the original file name (see attachment). Is there a macro, or way of setting, to remove the 'shortcut' prefix? I know I can do it manually, but there are too many files to do this.
Any help appreciated.