LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Art Art is offline
external usenet poster
 
Posts: 587
Default Replace formula to text

Hello:

I would like to replace a formula to the actual text of the formula. Fo E.G.
if I have in a cell "=A1", and I want to copy the formula to cell A25, it
will copy it like this, "=A25", but I want it to copy exactly like the
formula, "=A1". So how can I replace the formula in a cell to the actual text
of the formula without using a formula. Hope I'm explaining myself well, If
not ask please I'll explaine myself more. I need help on this. Thanks.
 
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
Replace text with formula hmm Excel Discussion (Misc queries) 3 October 31st 07 03:35 PM
Can I replace a ' at the beginning of a text cell using Replace Hilde Excel Discussion (Misc queries) 4 September 10th 07 06:22 PM
How do I replace text within a formula with a diff cell value? Eric_G Excel Worksheet Functions 1 July 18th 07 03:30 PM
How do I replace my vlookup FORMULA with just the TEXT of results J Lew Excel Worksheet Functions 1 May 26th 07 01:41 AM
find text in cell and replace it with part of the text in that ce. jules Excel Discussion (Misc queries) 3 May 3rd 07 10:18 AM


All times are GMT +1. The time now is 08:51 AM.

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

About Us

"It's about Microsoft Excel"