Reverse concatenate

[ryan640]

Hi,

I have a column with a line of text and then the next column has the exact same text but with additional info. I want to try and break them up so that I can just have the extra words.

In the below example I want to try and have a formula in column C that would cut out "hi my name is' or "I work at"

Example

A B
Hi my name is Hi my name is Ryan

I work at I work at the store

 

[steve the fish]

Try:

=TRIM(SUBSTITUTE(B1,A1,""))

 

[ryan640]

that worked for some but not all. It seems like the ones that are numbers are having a hard time breaking off. so for example column A would be Ice cream and B would be Ice cream size 8oz. I would just want 8oz.