Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtract text in one cell from another?
Hi,
I would like to subtract text in one cell from another, can anybody tell me if it can be done? For example: Cell A1 has "John Smith" Cell B1 has "John Smith violin teacher" Can I subtract cell A1's contents from cell B1's contents to leave "violin teacher"? |
#2
|
|||
|
|||
in C1 enter
=substitute(B1,A1,"") "BigIan" wrote: Hi, I would like to subtract text in one cell from another, can anybody tell me if it can be done? For example: Cell A1 has "John Smith" Cell B1 has "John Smith violin teacher" Can I subtract cell A1's contents from cell B1's contents to leave "violin teacher"? |
#3
|
|||
|
|||
I'd add...
=trim(substitute(B1,A1,"")) to get rid of the space between smith and violin. Or maybe even... =substitute(B1,A1&" ","") bj wrote: in C1 enter =substitute(B1,A1,"") "BigIan" wrote: Hi, I would like to subtract text in one cell from another, can anybody tell me if it can be done? For example: Cell A1 has "John Smith" Cell B1 has "John Smith violin teacher" Can I subtract cell A1's contents from cell B1's contents to leave "violin teacher"? -- Dave Peterson |
#4
|
|||
|
|||
"Dave Peterson" wrote: I'd add... =trim(substitute(B1,A1,"")) to get rid of the space between smith and violin. Or maybe even... =substitute(B1,A1&" ","") bj wrote: in C1 enter =substitute(B1,A1,"") "BigIan" wrote: Hi, I would like to subtract text in one cell from another, can anybody tell me if it can be done? For example: Cell A1 has "John Smith" Cell B1 has "John Smith violin teacher" Can I subtract cell A1's contents from cell B1's contents to leave "violin teacher"? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Forcing text onto new line in cell | New Users to Excel |