Comparing two cells in Excel

[Lego15]

Hello,
I need some help on how I can compare two cells in Excel and return a certain value in cell3:

Data:

Cell1= excel data Cell2= excel data review and automation

I want to return the following on cell3
Cell3= review and automation

Base on what Cell1 & Cell2 have in common, remove the word match in Cell2 and return remaining of Cell2 in Cell3.

Is this possible?

Thank You in advance for your advise!

 

[SkipVought]

Hi

"Is this possible?"

Probably, but I can't really understand what you are asking. Maybe you could post an example.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Also please post what code you have tried to implement so far.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Lego15]

This is an example:

Cell1 value= Bounty Cell2 value= Bounty Paper Product 10 rolls
I want cell3 value= Paper Product 10 rolls.

I am using a task automation software and it works but it skips some rows for some reason and do not really know why so I am trying to find another way to complete the task.
Is it clear now?

Thanks,

 

[mintjulep]

Will the phrase in cell1 always be the first part of the phrase in cell2?

 

[mintjulep]

Assuming that there is ALWAYS a match, and that it is ALWAYS the first part:

=RIGHT(B1,LEN(B1)-LEN(A1)-1)

 

[SkipVought]

You can use the Split function to parse the words in cell2

dim a, i as integer
a = split(cells(1,2).value," ")
for i = 0 to ubound(a)
  if cells(1,1).value <> a(i) then
     cells(1,3).value = cells(1,3).value & " " & a(i)
  end if
next

or it could be a function...

function CleanString(cel1 as string, cel2 as string) as string
  dim a, i as integer
  a = split(cel2value," ")
  for i = 0 to ubound(a)
    if cel1 <> a(i) then
       CleanString = CleanString & " " & a(i)
    end if
  next
end function

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Lego15]

There will always be a match.

The formula above works but the first letter doesn't come up.

In this example the cell3 value= roduct 10 rolls
The P of Product is cut.
How can I fix that?

Thanks a bunch for your help!

 

[mintjulep]

Get rid of the extra spaces at the end of whatever is in cell1

 

[Lego15]

How do I do that using a formula?

Thanks!

 

[PHV]

=RIGHT(B1,LEN(B1)-LEN(TRIM(A1))-1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lego15]

Yes it does!
I cannot thank you enough. I really appreciate your taking you time to help.

Take care,

Lego