Pasting into Outlook

jp22382

New Member
Joined
Dec 15, 2005
Messages
4
Hey all,

How can I paste just the text of a cell, without also pasting the border, fill color, etc?

even if I copy a cell that is plain text with no border or fill color, it is pasted in as an object and not as individual characters (if i try to edit it, it erases the entire thing)

(using office 2000)

Thanks!
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

vbsteve

Board Regular
Joined
Dec 11, 2003
Messages
99
Hi

Try selecting the text in the formula bar, then Ctrl + C, then just paste in outlook!

Steve
 

jp22382

New Member
Joined
Dec 15, 2005
Messages
4
my mistake, I didn't clarify....

The results in the cells are from a formula, so if I copy the data in the formula bar, I will just be copying the formula, not the actual text of the cell.

I am basically just needing to be able to copy prices from a quotation calculator and paste them into emails that are sent to customers.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,057
Messages
5,569,954
Members
412,300
Latest member
Chaneycr
Top