Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding contents of another cell to the middle of a line of text
fat in B2,
The brown X dog jumps in A2 =SUBSTITUTE(A2,"X",B2) now the problem is if this can be any type of letter? If it is a word it is easier. However note that all instances of X (case sensitive) will be replaced with the word fat -- Regards, Peo Sjoblom wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I put a horizontal line in the middle of a cell? | Excel Discussion (Misc queries) | |||
Insert Cell Contents in middle of web address | Excel Discussion (Misc queries) | |||
Adding cell contents in different worksheets | Excel Discussion (Misc queries) | |||
Possible to insert cell data in the middle of line of text? | Excel Worksheet Functions | |||
Adding a text label to a line. | Charts and Charting in Excel |