displaying a formula's answer into a separate cell

O

ounelly70

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..
 
T

Toppers

In your source w/sheet, select column with combined names, then do
Copy=>Paste Special=> Values which will "convert" the formulae to text. You
can then copy/paste to your second w/sheet.

HTH
 
M

Marcelo

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



"[email protected]" escreveu:
 
G

Gord Dibben

Copy then select a cell on other sheet and Edit>Paste Special>ValuesOK>Esc


Gord Dibben MS Excel MVP
 
R

Ron Rosenfeld

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..
Click to expand...

Copy/Paste Special/ Values
--ron
 
M

Marcelo

sorry I lose something on the first post, copy and past special values on the
new spreadsheet

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:
 
Top