Hi all,

I have over 500 records in Col A in the following format:

XXX-XX-0065-0 REG-PT
XXX-XX-0119-0 REG-FT
XXX-XX-1106-0 FRS
.
.
.


The numbers after the XXX-XX-????-0, illustrated with ???? varies.


What I need is a macro to move any three of these letters found in Column A to Column C and one row up.

REG-PT


REG-FT
FRS

Also, I would like a macro to move any one of these XXX-XX-????-0 to Column B and one row up.

Hoping there is a solution.

Thank you in advance for your support.

Regards,
rsrasc