Converting formulas to values
 

I have this part # in a Word table:
-TK85-AX
I try to copy it to an Excel file but I get a #NAME? error and on the fomula
bar appears like =-TK85-AX

What should I do?

Converting formulas to values
 

If it's just one cell, you can format the cell as text (in Excel) and paste into
the formula bar.

If it's multiple cells, maybe you could format the cells as text and paste
special|text. I didn't test this.

Byron720 wrote:

I have this part # in a Word table:
-TK85-AX
I try to copy it to an Excel file but I get a #NAME? error and on the fomula
bar appears like =-TK85-AX

What should I do?

--

Dave Peterson

Converting formulas to values
 

I would put it as ="-TK85-AX"

"Byron720" wrote:

I have this part # in a Word table:
-TK85-AX
I try to copy it to an Excel file but I get a #NAME? error and on the fomula
bar appears like =-TK85-AX

What should I do?

Converting formulas to values
 

Usually helps if you pre-format the cells in Excel to Text format before the
paste.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 09:28:01 -0700, Byron720
wrote:

I have this part # in a Word table:
-TK85-AX
I try to copy it to an Excel file but I get a #NAME? error and on the fomula
bar appears like =-TK85-AX

What should I do?