help with formula to Extrac certain word from row

Dear All

I was wondering whther someone can help me with the follwoing:

I have a spreadsheet with list of names and whther they logged in or logge dout

the names are in column a starting at a2 like below

FFF logged in
fff Logged out
ggg logged in
ggg logged out
kkkkkkkkk logged in
kkkkkkkkk logged out

I need a formula to look at each row in column a and extract the word either logged in or logged out and copy the word logged in or logged out in column b.

I have enclosed a sample spreadsheet, basically in column b2 it should say logged in and in column b3 should say logged out and so on

If I can then delete the word logged in or logged out from column A for each name that will be really useful if not possible only the above would do.

Thanks for help in advance

Try in B2 and drag down

Formula:

Please Login or Register  to view this content.

=TRIM(RIGHT(A2,LEN("logged out")))

copy down

Thnak you so much for the quick response. Boh solutions worked perfectly