Posts by ixladxi

    Re: Macro Help

    No reason for using code except I thought it had to be done that way. This is for a list of numbers.

    Input Column is

    Desired Output Column is
    AC_VOLUME_4:Assets:HR Images:1:12:123:123456.PSD
    AC_VOLUME_4:Assets:HR Images:6:65:654:654321.PSD

    Does that make more sense?

    Is there a way to create a macro that creates

    "AC_VOLUME_4:Assets:HR Images:7:75:752:752388_V1.PSD"

    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.

    [TABLE="width: 836"]