| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Cells Value- Not Formula?
Hey guys, this is giving me a little trouble and it looked like this
would be a good place to ask. i used the CONCATENATE formula on a workbook and need to transfer the results to a seperate workbook. Unfortunatly it copies the formula and not the values. Is it possible to do the latter? thanks -ben |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Cells Value- Not Formula?
Use EditPaste SpecialValues
-- Ian -- wrote in message oups.com... Hey guys, this is giving me a little trouble and it looked like this would be a good place to ask. i used the CONCATENATE formula on a workbook and need to transfer the results to a seperate workbook. Unfortunatly it copies the formula and not the values. Is it possible to do the latter? thanks -ben |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Cells Value- Not Formula?
thanks ian, if there was a m.p.w.m.noob i would have posted there
Ian wrote: Use EditPaste SpecialValues -- Ian -- wrote in message oups.com... Hey guys, this is giving me a little trouble and it looked like this would be a good place to ask. i used the CONCATENATE formula on a workbook and need to transfer the results to a seperate workbook. Unfortunatly it copies the formula and not the values. Is it possible to do the latter? thanks -ben |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Cells Value- Not Formula?
Select the cells in question.
Right click in the selection and choose "Copy". Right click *again* in the selection and choose "Paste Special". Click on "Values", then <OK. Now, navigate to your "other" WB and right click in your starting cell, And choose "Paste". Go back and close your original WB, *without* saving, to preserve the original formulas. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message oups.com... Hey guys, this is giving me a little trouble and it looked like this would be a good place to ask. i used the CONCATENATE formula on a workbook and need to transfer the results to a seperate workbook. Unfortunatly it copies the formula and not the values. Is it possible to do the latter? thanks -ben |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Cells Value- Not Formula?
Using Paste SpecialValues straight into the second WB is a quicker way to
achieve this. -- Ian -- "RagDyer" wrote in message ... Select the cells in question. Right click in the selection and choose "Copy". Right click *again* in the selection and choose "Paste Special". Click on "Values", then <OK. Now, navigate to your "other" WB and right click in your starting cell, And choose "Paste". Go back and close your original WB, *without* saving, to preserve the original formulas. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message oups.com... Hey guys, this is giving me a little trouble and it looked like this would be a good place to ask. i used the CONCATENATE formula on a workbook and need to transfer the results to a seperate workbook. Unfortunatly it copies the formula and not the values. Is it possible to do the latter? thanks -ben |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Cells Value- Not Formula?
I know that!
Just didn't say it because I'm old and forgetful. (Been using that excuse a lot lately.)<g -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ian" wrote in message ... Using Paste SpecialValues straight into the second WB is a quicker way to achieve this. -- Ian -- "RagDyer" wrote in message ... Select the cells in question. Right click in the selection and choose "Copy". Right click *again* in the selection and choose "Paste Special". Click on "Values", then <OK. Now, navigate to your "other" WB and right click in your starting cell, And choose "Paste". Go back and close your original WB, *without* saving, to preserve the original formulas. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message oups.com... Hey guys, this is giving me a little trouble and it looked like this would be a good place to ask. i used the CONCATENATE formula on a workbook and need to transfer the results to a seperate workbook. Unfortunatly it copies the formula and not the values. Is it possible to do the latter? thanks -ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a formula which calculates empty cells | Excel Discussion (Misc queries) | |||
| copying adjacent cells with formula | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Copying formula to different cells | Excel Worksheet Functions | |||
Linear Mode
