Thanks. Forgot to mention, this code will need to function within an existing, written macro that reformats the orders. This needs to be a new command line within that macro. Is this format designed for use within a cell in the worksheet?

We get orders in and run a macro on them to reformat. Sorry if I'm not explaining this well.