moving data

[robmac]

I have a list of data, all in one column. I need to separate the date into 3 columns. How do I do that?

Here's what I have:

Column A
Business
Contact
<empty cell>
email

What I need is:

Column A Column B Column C
Business Contact Email

Thanks

[6StringJazzer]

I assume you have many entries. In the attached example the data is in column A. See formulas in Columns C:E for solution. Copy down as many rows as necessary. When done, select C:E, Copy, then Paste Values. Delete columns A:B to clean up.

[robmac]

Thanks very much!! That worked perfectly.

Now just one other issue. In the cells that contain the email address, it actually says "Email: bill.smith@example.com".

I will be importing this list to an email marketing program, so I need to remove the words "Email:". There are a total of 550 records.

Is there a global 'search and delete' function I can perform?

[robmac]

Just solved the above myself with a simple Replace function.

Thanks anyway!