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" <UABCSA@discussions.microsoft.com> wrote in message
news:7C049534-4F1C-4B39-960A-3E46101CD055@microsoft.com...
> 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" <UABCSA@discussions.microsoft.com> wrote in message
news:7C049534-4F1C-4B39-960A-3E46101CD055@microsoft.com...
> 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" <UABCSA@discussions.microsoft.com> wrote in message
news:7C049534-4F1C-4B39-960A-3E46101CD055@microsoft.com...
> 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?