Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pam Coleman
 
Posts: n/a
Default merge two cells

I have information in (example: f4, f5, f6, f7. I want to merge it into F4,
but still be listed in a column: example
Bob Smith
Joe White
Betty Snow
Jill Jones
I want it to look like this but be in F4, I tried to merge the cells, but
it deletes the information except the first name. Is there an easy way to do
this? f4& f5&.... puts it in a line across in f4, but I want it as a list.

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
why would the merge box in the format cells menu be greyed out pm Excel Discussion (Misc queries) 4 February 20th 06 04:45 PM
Merge Cells GARY Excel Discussion (Misc queries) 0 February 15th 06 06:21 PM
How do I merge two cells in a column AliWitt Excel Discussion (Misc queries) 1 February 9th 06 10:37 PM
Excel should have the option to merge contents when merging cells. Ceiling Tile 01 Excel Discussion (Misc queries) 2 August 31st 05 11:03 PM
How do I merge cells in Excel, like just 2 cells to make one big . chattacat Excel Discussion (Misc queries) 2 January 19th 05 04:25 PM


All times are GMT +1. The time now is 02:36 PM.

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"