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