View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] myurbanchild@gmail.com is offline
external usenet poster
 
Posts: 1
Default Adding contents of another cell to the middle of a line of text

To save me HOURS of work, i really need to know if there is a way to
replace a part of a line of text with the contents of another cell.
For example if i have: The brown X dog jumps. I would need it to
say: The brown fat dog jumps.
The first line (The brown X dog jumps.) being in column 1 and the word
(fat) to be added in place of the X located in column 2.

I know how to combine the columns but not when the text has to go into
the middle rather than at the beginning or end.
Any HELP i would greatly appreciate.
-Lara