Macro to pars data

[Dkeller12]

I have a spreadsheet that contains names and addresses. What I need is a macro that will search each address in column F and if the address contains an apartment number (100 MAIN ST APT 123) I need to have the APT 123 stripped out and moved to Column G leaving 100 MAIN ST in column F. This must loop through the entire column F and do this for any address that contains and APT #.

Can anyone help me out with this request?

Thanks in advance.

 

[The_Barman]

if there is currently data in Column H... insert a new column into H
highlight Column G... [ctrl]+[f]... find " APT " replace with an obscure character and "APT " ("~APT " for example)
Data > Text To column > Delimited > use the character as delimiter (~ for example)
this should create a new column with anything that was after APT in column H

 

[Dkeller12]

That worked perfectly. Thank you for the help and the quick response.