I've been working for a while with tracking numbers that come in through an excel spreadsheet.

The tracking numbers are in single cells and are in the format, xxxyyy#######zzzz (All numbers)

For various reasons, I need to leave the original number unchanged. However, I also need to have it split on a seperate worksheet.

Where:
the xxx goes in B2
the yyy goes in C2
the ####### goes in A23
the zzzz goes in B23

I did not design it. I don't know why they designed it this way. I cannot change the design. I wish I could.

So I'm stuck
1) manually typing in the numbers into the four locations.
2) Copying the tracking numbers to a new tab, using text to columns, fixed width to split the string. Than copying and pasting all four to the correct locations.

Both are a huge time waste.

What I would like to be able to do is, copy the whole tracking number, than run a macro that takes the string from the clipboard, and auto splits the string into the four sections and pastes the results into the correct cells for me.

Anyone know how or even if this can be done?