Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"." & 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!!! |
#2
|
|||
|
|||
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!!! |
#3
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table with Text | Excel Discussion (Misc queries) | |||
Check if table contains text | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |