Hi,

This is my first post here. I'm looking forward to being able to help where I can and get help when I need it. At the moment I need some help. I've searched the net looking for a solution and haven't found one.

My basic problem is having more than one line of information in a cell. I'm required to keep email addresses and sometimes phone numbers and names in one cell for each row. But I'm also required to upload the data in an Access database. I'm getting tried of manually going through 3000+ records in Excel and manually fixing each one.

What I want to do is create a macro that will delete information I don't need and end up with one good email address per cell per row, which would be the first line. Each instance of information except the last (not always true) end with alt+enter (carriage return). I was looking for an inspect function on a string, but VBA doesn't seem to have that. Anyway, my data looks something like this.

--------------------------------
bill.smith@somewhere.com
bill.smith@somewhere.else.com
999-999-9999
--------------------------------
joe.smith@herethere.com
123 Main Street
Myplace, HM 9999
--------------------------------
joe.jones@therewhere.com
joe.jones@therewhere.here.com
Sec'y Janet Smith
--------------------------------
Empty
--------------------------------
bill.william@nowhere.com
--------------------------------

Can anybody help to get me started on this?

Thanks in advance.

JDB