LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default Multiple Row to columns

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using functions to compare multiple columns for mismatch of cells MDIAZ451 Excel Worksheet Functions 3 February 13th 06 02:49 AM
making multiple columns when printing long datasheet Piet Excel Discussion (Misc queries) 1 November 11th 05 04:00 AM
Justify text across multiple columns fins2r Excel Discussion (Misc queries) 4 October 26th 05 05:07 PM
Pivot Table combining multiple columns Pete Petersen Excel Discussion (Misc queries) 1 January 13th 05 07:56 PM
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? hims Excel Worksheet Functions 2 October 27th 04 07:03 PM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"