#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
received "a=formula" instead of =formula after exporting data - wh Jane Excel Worksheet Functions 0 January 31st 07 09:18 PM
Formula to sum data from a data range mike the new guy Excel Discussion (Misc queries) 3 January 18th 06 08:56 AM
Formula to capture historical data from data that changes daily DKennedy Excel Discussion (Misc queries) 0 December 28th 05 08:24 PM
Formula to capture historical data from data that changes daily DKennedy Excel Worksheet Functions 0 December 28th 05 08:23 PM
Any cell containing formula seen as data instead of formula Jeffry61 Excel Worksheet Functions 2 September 23rd 05 02:04 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"