I need shortcut in Excel for coping text only and not the entire c
 

In Excel is there a shortcut that copies the text (value) only and not the
entire cell. If you select a cell in a spreadsheet and use CTRL-C it copies
the cell and contents. If you want the text only from the cell you must use
a mouse to place a cursor there and drag/highlight all of text this takes too
much time when editing vast amounts of data. Is there a shortcut to select
the text (value) only of a cell without using a mouse?

No, there is not such a short cut

--
Regards,

Peo Sjoblom


"UABCSA" wrote in message
...
In Excel is there a shortcut that copies the text (value) only and not the
entire cell. If you select a cell in a spreadsheet and use CTRL-C it
copies
the cell and contents. If you want the text only from the cell you must
use
a mouse to place a cursor there and drag/highlight all of text this takes
too
much time when editing vast amounts of data. Is there a shortcut to
select
the text (value) only of a cell without using a mouse?

Thank you

"UABCSA" wrote:

In Excel is there a shortcut that copies the text (value) only and not the
entire cell. If you select a cell in a spreadsheet and use CTRL-C it copies
the cell and contents. If you want the text only from the cell you must use
a mouse to place a cursor there and drag/highlight all of text this takes too
much time when editing vast amounts of data. Is there a shortcut to select
the text (value) only of a cell without using a mouse?

You can assign a shortcut key to the following macro.


Sub CopyText()
Dim D As New DataObject
D.SetText ActiveCell.Text
D.PutInClipboard
End Sub

You'll need a reference to the MSForms library. In the VBA
Editor, go to the Tools menu, choose References, and scroll to
and check "Microsoft Forms 2.0 Object Library".

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"UABCSA" wrote in message
...
In Excel is there a shortcut that copies the text (value) only
and not the
entire cell. If you select a cell in a spreadsheet and use
CTRL-C it copies
the cell and contents. If you want the text only from the cell
you must use
a mouse to place a cursor there and drag/highlight all of text
this takes too
much time when editing vast amounts of data. Is there a
shortcut to select
the text (value) only of a cell without using a mouse?

If the cell below your target is empty, you can use Ctrl-' (single quote) to
make a duplicate copy of the text in the cell above, then cut that text to
the clipboard


"UABCSA" wrote in message
...
In Excel is there a shortcut that copies the text (value) only and not the
entire cell. If you select a cell in a spreadsheet and use CTRL-C it
copies
the cell and contents. If you want the text only from the cell you must
use
a mouse to place a cursor there and drag/highlight all of text this takes
too
much time when editing vast amounts of data. Is there a shortcut to
select
the text (value) only of a cell without using a mouse?