First off, I am not very familiar with excel, so when answering pls
make it easy for a beginner to understand. I have a customer list in
excel. It have their first and last name in one cell with a space
between the two. I would like to know how to remove the space and
instead have a period inserted between them. I then would like to add
an @ symbol followed by their email provider. I need to make a csv
file so i can upload it to a web database and create a customer
newsletter list. The end result should look like this:



Thanks! Eric