How do I convert cells containing formulas to text (value returned

K

Kim

Is there a way to convert the data returned from a formula to text and remove
the formula? For example, I have a cell containing this formula:
=IF('Current Registrants'!F5="yes", 'Current Registrants'!J5, 0). After the
value has been returned, I would like to convert that cell to the return
value & get rid of the formula. Is this possible? Thank you for your
suggestions.
 
J

Jason Morin

Copy the formula cell and go to Edit > Paste Special.
Click on "Value" and press OK.

HTH
Jason
Atlanta, Ga
-----Original Message-----
Is there a way to convert the data returned from a formula to text and remove
the formula? For example, I have a cell containing this formula:
=IF('Current Registrants'!F5="yes", 'Current
Click to expand...
Registrants'!J5, 0). After the
 
K

Kim

Thanks!

Jason Morin said:
Copy the formula cell and go to Edit > Paste Special.
Click on "Value" and press OK.

HTH
Jason
Atlanta, Ga

Registrants'!J5, 0). After the
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Searching the formula (not the value) for a text string 1
Vlookup and return sheet name also 2
VLOOKUP source values are a formula result. Getting #N/A 7
Using formula to convert date result to text 3
Returning Multiple Results with Vlookup 1
Returning 1 of 4 values if conditions are met 4
Can UDF return a customized hyperlink? 3

Top