ExcelBanter - View Single Post - displaying a formula's answer into a separate cell

Ron Rosenfeld

On 26 Sep 2006 13:24:38 -0700, wrote:

Hello, I'm having a problem with combining strings, basically I will
have two cells with names that will be combined so I did the

=a1 & " " & a2

assuming that a1 is first name and a2 is second name,
then what I am trying to do is copy the full name over to a different
spreadsheet
but when I copy that cell over, it just copies the formula... :(

So the only thing I can think of is making the formula output to a
different cell that is formated to text, then I can copy that cell over
to the other spreadsheet..... Of course I'm probably going about this
all wrong and I'm sure that there is a more simple method...

Any help would be greatly appreciated..

Copy/Paste Special/ Values
--ron