Hi,

please can you type me macro that will find in all A:A column words containing "." and put them into the second column?
Also, in third column, I would like to have all words, except all what is after "."

Example:

A B C
aaa aaa
aa.a aa.a aa
bbb bbb
bbb bbb
ccc ccc
cc.c cc.c cc