| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy the contents of a range of text cells and paste into one cell?
Hi, Excel 2003 question: I have a sheet that contains text in consecutive cells (in a column), I need to copy all the consecutive cells' texts into one cell in a separate spreadsheet. Is there any quick way to do this? Just selecting the individual texts and copy/pasting is time consuming and a pain. I have multiple occurrences of this and need to find a quick way. All help and suggestions very much appreciated. Thanks, Dave. -- davfin ------------------------------------------------------------------------ davfin's Profile: http://www.excelforum.com/member.php...o&userid=36012 View this thread: http://www.excelforum.com/showthread...hreadid=557961 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I paste text data into ONE cell only? | Excel Discussion (Misc queries) | |||
| copy paste delete cell contents | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| How do I edit, copy and paste text in excel cells? | New Users to Excel | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
Threaded Mode
