Copy from Word to Excel

[Guest]

When I copy text from an emailed Word file, paste it into Excel 2003
worksheet, my formulas in the worksheet won't work. If I manually type in
the text in the cell in the worksheet, the formula will work. Any
suggestions on how to get the formulas to recognize the Word text in the
formula? Thank you in advance.

 

[Harlan Grove]

When I copy text from an emailed Word file, paste it into Excel 2003
worksheet, my formulas in the worksheet won't work. If I manually type in
the text in the cell in the worksheet, the formula will work. . . .

Are you pasting from Word tables? It's possible such text includes
nonbreaking spaces (decimal character code 160). You'd need to remove such
characters from pasted text. Simplest to enter the formula =CHAR(160) in
some other cell, copy it to the clipboard, select the data pasted from Word,
run the menu command Edit > Replace, in the Find what field clear anything
that's there and press [Ctrl]+V to paste a nonbreaking space copied from the
cell formula, clear anything in the Replace with field, and click the
Replace All button.

 

[Guest]

Excel is treating your pasted value(s) as text. You can quickly convert a
range of cells to text by copying an empty cell, selecting the offending
values, and using Edit-Paste Special-Values-Add

Alternatively, in the formula(s) that reference the offending cells, wrap
the reference in the VALUE() function