COPY the content of a cell AS IS.

[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

 

[CLR]

Copy > PasteSpecial > Values

Vaya con Dios,
Chuck, CABGx3

 

[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

 

[xianwinwin]

cool. thank