ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data from formula (https://www.excelbanter.com/excel-discussion-misc-queries/192025-data-formula.html)

spiz via OfficeKB.com

data from formula
 
How can i make "find and replace"(control-f, tab 2) work on data that is the
result of a formula and is paste linked to the original data.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1


joel

data from formula
 
clcik on one cell with the string Control-f tab2 and highlight this data with
the mouse and press cntl (c). the go to find and replace and click on either
from or to box and type cntrl V. the find and replace box will not give you
the Copst or Past option, but the ekyboard character Cntl C and Cntl V do
work.

"spiz via OfficeKB.com" wrote:

How can i make "find and replace"(control-f, tab 2) work on data that is the
result of a formula and is paste linked to the original data.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1




All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com