Comparision of 2 cells

**mvel_sky** · 05-08-2009, 12:19 AM

Dear Friends,

I have a query.

See i have 2 cells

Cell1 with Value : APPLE
Cell2 with value : APLE

I want to compare these 2 cells and return the missing letter. Answer : "P"

Is it possible?

Please help me.

Thanks regards
M.Velmurugan

**martindwilson** · 05-08-2009, 02:53 AM

how many times are you going to ask this question?

**Raiby** · 05-08-2009, 03:10 AM

mubashir aziz gave you the answer.

**zbor** · 05-08-2009, 03:24 AM

I try to do something.. Don't know did I make it.. please, try and test it.

Only thing is that first word must be longer and first letter of first word must be correct.

So apple 1.st word and aple 2.
and
gpple and apple will return missing a, so you must write it correct...

Book1(1).xls

**mvel_sky** · 05-08-2009, 04:03 AM

Mr.Martindwilson

I will repeat the question till i get the answer.

Mr.Zbor

Thankyou very much for your valuable input.

Regards
M.Velmurugan

**squiggler47** · 05-08-2009, 04:29 AM

I think perhaps you should repeat, perhaps 1000 times :-

"I will learn manners, and be greatful for free help"

By annoying valuable members of this community and reposting the same question although you have been given the best solution, will only result in either nobody wanting to help or you being removed from the forums?

many members of this forum are Excel experts and earn a living from it by charging consultancy fees, even though I have used spreadsheets for over 22 years and have made a living from it in the past I still apreciate the $/£ value of their help in places where I have a knowledge gap.

Please take time to concider the value of this rescource and the great community serive that it affords its members.

Regards

Darren

**martindwilson** · 05-08-2009, 04:34 AM

I will repeat the question till i get the answer.

that is not quite the etiquette is it?
however to compare 2 cells as you ask is a possible.
there you go
question answered
if you want a fuller answer give more examples of what you really want to achieve
how many characters would you want to find
would they always be missing from the same place
or anywhere in the word e.g pple,appe,appl, and so on

**mvel_sky** · 05-08-2009, 04:40 AM

Dear Friend,

Only after repeating the same question. I got a suberb input from Mr.Zbor.

Once again i thank Mr.Zbor. I was searching for the answer for past one week. At last i got it.

The reason why i have repeated the question is, the people are not seeing the older threads. They are focussing on new threads only.

So to get the attention of the members i have done this. Sorry if anybody got disturbed.

Though you got disturbed i got the answer. Thats it.... Thanks a lot to the forum..

Regards
M.velmurugan

**squiggler47** · 05-08-2009, 04:44 AM

Read the forum rules, on posting a new reply "BUMP!!!"

Originally Posted by mvel_sky

Dear Friend,

Only after repeating the same question. I got a suberb input from Mr.Zbor.

Once again i thank Mr.Zbor. I was searching for the answer for past one week. At last i got it.

The reason why i have repeated the question is, the people are not seeing the older threads. They are focussing on new threads only.

So to get the attention of the members i have done this. Sorry if anybody got disturbed.

Though you got disturbed i got the answer. Thats it.... Thanks a lot to the forum..

Regards
M.velmurugan