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?