| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert cells containing formulas to text (value returned
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. |
|
#2
|
|||
|
|||
|
select the range
copy edit-paste special-values "Kim" wrote in 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 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. |
|
#3
|
|||
|
|||
|
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 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. . |
|
#4
|
|||
|
|||
|
THANK YOU!
"N Harkawat" wrote: select the range copy edit-paste special-values "Kim" wrote in 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 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. |
|
#5
|
|||
|
|||
|
Thanks!
"Jason Morin" wrote: 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 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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
Linear Mode
