| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the fomula...?
Anyone know how to remove the formula and leave the data?
I filled a column A3 with an IF(B3="",C3,B3). Now I want to remove the IF function but leave the data that was replaced. Tks, Don |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the fomula...?
What I normally do is copy the data then 'paste special' ..... 'values' and
paste right over top of the formula. This will copy the values overtop of your formula. "Donald King" wrote: Anyone know how to remove the formula and leave the data? I filled a column A3 with an IF(B3="",C3,B3). Now I want to remove the IF function but leave the data that was replaced. Tks, Don |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the fomula...?
Copy.
Paste SpecialValuesOKEsc. Gord Dibben MS Excel MVP On Fri, 10 Nov 2006 13:39:01 -0800, Donald King wrote: Anyone know how to remove the formula and leave the data? I filled a column A3 with an IF(B3="",C3,B3). Now I want to remove the IF function but leave the data that was replaced. Tks, Don |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the fomula...?
Hi donald...try copypaste column C into column A or Delete Column A and
Column B. "Donald King" wrote: Anyone know how to remove the formula and leave the data? I filled a column A3 with an IF(B3="",C3,B3). Now I want to remove the IF function but leave the data that was replaced. Tks, Don |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the fomula...?
If you do that you'll lose the data. You need to use Paste Special/ Values.
-- David Biddulph "rml" wrote in message ... Hi donald...try copypaste column C into column A or Delete Column A and Column B. "Donald King" wrote: Anyone know how to remove the formula and leave the data? I filled a column A3 with an IF(B3="",C3,B3). Now I want to remove the IF function but leave the data that was replaced. Tks, Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to prevent Remove Split or Unfreeze Panes? | Excel Discussion (Misc queries) | |||
| How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
| How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
| remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
| To copy fomula | Excel Worksheet Functions | |||
Linear Mode
