LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LisaJ27
 
Posts: n/a
Default Combining second row to first row

How do I make this:

John Edwards
24 Main St NY NY 08000
(all data is in seperate cells)

Look like this:

John Edwards 24 Main St NY, NY 08000
(Each cell moved to top line)

There are multiple rows of this data. Thanks

 
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
Combining mutiple columns into one column noelcantona Excel Worksheet Functions 1 October 16th 05 06:18 PM
combining countif with AND function Daesthai Excel Worksheet Functions 3 October 13th 05 05:37 AM
Combining text from multiple columns into 1 stelee Excel Discussion (Misc queries) 3 July 6th 05 11:04 AM
Combining workbooks with some variable field names Bob Dobalina Excel Discussion (Misc queries) 8 May 17th 05 09:48 PM
Combining Tables metrueblood Excel Discussion (Misc queries) 3 February 2nd 05 10:05 PM


All times are GMT +1. The time now is 12:38 PM.

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

About Us

"It's about Microsoft Excel"