if cell = "Its a One" then cut from previous cell, last 8 characters and paste in next cell

[Karl Adcock]

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

 

[alansidman]

What do you want to put in column D if the statment is not true? Assuming you want to put a blank string use this formula in column D.

=if(B2="Its a One",right(A2,8),"")

Alan

 

[Karl Adcock]

Thanks for the reply. I was hoping to do this from vb as I have numerous rows that contain the 8 characters that require moving.