Subtract text in one cell from another?

G

Guest

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"?
 
D

Dave Peterson

I'd add...

=trim(substitute(B1,A1,""))

to get rid of the space between smith and violin.

Or maybe even...

=substitute(B1,A1&" ","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
multiple subtraction from one field 1
need to subtract one cell from each cell in a row 1
why cant i subtract one cell from another? 3
Excel Linking Multiple cells to One cell for Results 0
% query 11
Conditional Formatting and cloring cells and date calculations 1
formula that strips the first letter of the first name in a cell 5

Top