Hi all,
I need help in excel, I have these data in the first column,
TR000000ADC Display Budget
TT000000A3_DC Overtime statement
TU000000B4321 Display Call out time

I want to make it into two columns and extract only the last few
characters from the first column and make the final document look like
below

ADC | Display Budget
A3DC | Overtime statement
B4321 | Display Call out time

Can anybody provide help in this regard, I want this in macro as the
data is 150 rows...thanks

Rgds

Ajit