COPY the content of a cell AS IS.

X

xianwinwin

Hi all,

is there any functions (I guess Text related) that can copy the conten
of a cell as is? in other words, say I have cell A1 with the content of


a man dance with his wife in chicago, my home town
and A2 has:
=REPLACE(A1,30,8,"Miami")

if I drag B2 to B10 the result will be Miami (b2-b10). I would like t
COPY the sentence:
a man dance with his wife in Miami, my home town AS IS. meaning n
formula just the text in cell A2. is there's a way doing it?

thank
 
D

Debra Dalgleish

If you want to copy the text by dragging:

Select cell B2
Point to the cell border
Hold the RIGHT mouse button, and drag to cell B10
Release the mouse button
From the menu that appears, choose Copy Here as Values Only
 
Top