Is there a way to create a macro that creates
in column B from
in column A?
“AC_VOLUME_4:Assets:HR Images:” is standardized. The rest of the file path is based off the file name. The folder structure is always broken down to the first (3) digits of the file name.
Thank your help in advance.