"." & a "+" added 2 a table reformatd as text in Word???
 

I'm needing to take info from 2 cells and merge them into one cell in excel.
I copy the info, transfere it to word, change it from a table to text,
replace the "." & "+" with nothing (which does work) and then copy and paste
back to excel. When I do this, some of the cells, but not all add the
replaced text back in. When I try to replace in excel, it says it has
successfully replaced it, but nothing changes. Someone please, help me either
find a solution, or else help me dig a hole to bury this thing in.....
thanks!!!

Hi-
I don't think Word has much to do with this.

In EXCEL, what are the contents of the cells that are not changing as you
want them to (copy the content from the formula bar)? What (in Excel) are
you trying to find and replace?

"Leslie" wrote in message
...
I'm needing to take info from 2 cells and merge them into one cell in
excel.
I copy the info, transfere it to word, change it from a table to text,
replace the "." & "+" with nothing (which does work) and then copy and
paste
back to excel. When I do this, some of the cells, but not all add the
replaced text back in. When I try to replace in excel, it says it has
successfully replaced it, but nothing changes. Someone please, help me
either
find a solution, or else help me dig a hole to bury this thing in.....
thanks!!!

Perhaps you want =concatenate(a1," ",a2) this will combine text or whatever
from 2 cells into one cell.

"Leslie" wrote in message
...
I'm needing to take info from 2 cells and merge them into one cell in
excel.
I copy the info, transfere it to word, change it from a table to text,
replace the "." & "+" with nothing (which does work) and then copy and
paste
back to excel. When I do this, some of the cells, but not all add the
replaced text back in. When I try to replace in excel, it says it has
successfully replaced it, but nothing changes. Someone please, help me
either
find a solution, or else help me dig a hole to bury this thing in.....
thanks!!!