| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
"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 | |||
Hybrid Mode
