Subtract text from a text cell

**kraut** · 07-25-2014, 11:53 AM

Hello! I need to subtract all the text in one cell, from another cell.
I have for example:

A1 Airline Bus 70C/3R5 Eagle
B1 Airline Bus Eagle

What formula can I use that could give me in cell C1 70R/3R5 ?

Thanks!

**Pete_UK** · 07-25-2014, 11:56 AM

I think a few more examples are needed, so we can see the variations which can occur in column B. Please attach a sample file.

Pete

**AlKey** · 07-25-2014, 11:58 AM

try this one

in B1

=TRIM(MID(SUBSTITUTE(MID(A1,FIND("/",A1)-3,255)," ",REPT(" ",255)),1,255))

	A	B
1	A1 Airline Bus 70C/3R5 Eagle	70C/3R5

**kraut** · 07-25-2014, 12:47 PM

Thanks for the prompt response guys!
Here an example I just made.

Book1.xlsx

**AlKey** · 07-25-2014, 12:52 PM

I am looking at your file and but I don't think I understand it. Care to elaborate more on what exactly you need?

Thanks

**kraut** · 07-27-2014, 06:44 PM

Hello AlKey,

Sorry I thought was already very simple!! I want to subtract the text in column B from the text in column A, and display it in column C!
So, if I have in cell A the sentence "This is your forum" and in cell B the words "is your", cell C should display "This forum" (This is your forum - is your = This forum)
Hope this time is clear!
Thanks!

**AlKey** · 07-27-2014, 08:47 PM

Unfortunately, there appears to be no logic, at least not obvious to me, or any particular order in which this task can be accomplished. These parts of the string can be extracted but the formula will not work on anything else for the reasons stated earlier.

**Pete_UK** · 07-28-2014, 04:51 AM

Put these formulae in the cells stated:

D1: =LEFT(B1,FIND(" ",B1))
E1: =LEFT(SUBSTITUTE(B1,D1,""),FIND(" ",SUBSTITUTE(B1,D1,"")))
F1: =SUBSTITUTE(B1,D1&E1,"")
G1: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,D1,""),E1,""),F1,"")

then copy down, as in the attached file. This assumes that you have 3 words to be replaced each time, as your example shows.

Hope this helps.

Pete