Good Morning All,
I'm trying to write a macro to split the contents of a cell when the contents are separated by a semicolon ;
This is for an automatic e-mail macro, the cell I'm trying to split contains the names of people previously e-mailed, like so. Bob Johnson; Michael Faraday
I'd like to split the names up and then search each name on another sheet and return their e-mail address.
I found the below, which splits the contents of cells into more cells.
http://www.excelforum.com/excel-prog...-at-every.html
Any help or advice would be greatly appreciated.
R
Bookmarks