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

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

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

"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