I know this seems so simple...maybe I'm now frustrated due to looking at the
computer screen all day. I am formulating an excel sheet as my data base to
create mail merge. The website that I have gotten the information from pastes
to the excel sheet as such:

File Numer 1233112 John Doe
12563 E Washington St
Mesa, AZ 85296

I need to date to read as following

File Number 1233112 John Doe 12563 E Washington St
Mesa, AZ 85296


Paste special does not work for this function and I have over 7,000 records
to sort through.... Please Help