How do I select and copy text from multiple cells in one go? Excel

[mistercitizen]

I can only selct text from on cell at a time.

How do I copy text from multiple cells in on go?

Thanks in advance.

 

[SkipVought]

mc,

I do not understand why you cannot select multiple cells containing text, Copy & Paste. It is done ALL THE TIME.

Please explain your problem in greater detail.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mistercitizen]

OK, I can only select texxt from individual cells - ie: I double-click on a cell and I am only allowed to select text from the cell.

How do I select and copy text from multiple cells?

 

[01Patrik]

worst-case: you can always use =A1&B1&C1 (where the cells contains text). If you need the texts copied further, then copy / paste-special: 'values' Then you definately get the text.




// Patrik

 

[SkipVought]

I was confused by your use of SELECT. You can SELECT every swingin' cell on a sheet.

You want to EDIT text from multiple cells at one swell foop. There is no way to accomplish that directly. However, you can use a multi-step process like Patrik suggested above. To clarify his post...
[tt]
1) create an expression in another cell that concatenates the cells containing the text you want to edit.

2) copy that expression

3) in the SAME CELL Edit/Paste Special and select the Values option
[/tt]
VOLA!

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884