Karl Adcock
New Member
- Joined
- Jul 10, 2010
- Messages
- 19
Hello all
A B
2 │ *CIP STOPPED DUE TO HEPA FAULT* │ 0 │ 00:00:00 Its a One
I would like to cut the last 8 characters from the cell in column A if the text in column B reads "Its a One" for each time "Its a One" appears in column B and paste it in column D
I have "Its a One" in column B so that I can choose the rows from which I want to cut the last 8 characters from.
Any help greatly appreciated.
Karl Adcock
A B
2 │ *CIP STOPPED DUE TO HEPA FAULT* │ 0 │ 00:00:00 Its a One
I would like to cut the last 8 characters from the cell in column A if the text in column B reads "Its a One" for each time "Its a One" appears in column B and paste it in column D
I have "Its a One" in column B so that I can choose the rows from which I want to cut the last 8 characters from.
Any help greatly appreciated.
Karl Adcock