hi Mathew,

Difficult to provide a proper answer based on details posted but this
might point you in the right direction.

Assuming the data has been imported / copy & pasted into Excel it is
likely that that each 'field' is seperated by a charcter (delimiiter),
hence you have might have several lines in each cell. Use the 'text to
columns' under 'data' to split this information across columns. Use
it again to split email / hyperlink.

There are many articles on this subject in this newsgroup.

HTH

Regards

Michael