displaying a formula's answer into a separate cell
Hi Ounelly,
you trying to run a formula in a pre format text cell, excel will understand
it as a text.
format the column as general retype the formula and copy it down.
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
" escreveu:
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..
|