Pasted values not recognised

[parbynat]

Can someone help with this?

When I copy 2 cells that contain the same word that were generated from a formula and paste them into A1 and A2 and then use =IF(A1=A2,1,"") in A3 it returns blank.
When I manually type in the same 2 words it is fine.
What can I do to overcome this?

Thanks

[Sam Capricci]

Are you using paste special >>> values?

[parbynat]

I have just tried paste special and selected values instead of all.
I also tried all 3 options under values.
Still no luck.

[Sam Capricci]

I cannot replicate what you are explaining in post #1. There are instructions at the top of the post explaining how to upload a sample workbook.

[parbynat]

Ok I'll try.

[Sam Capricci]

in the sample you posted, A1 and B1 are not the same. A1 has an extra space at the end while B1 does not.
try this in an empty cell =a1=b1 and it will return false.
try this in another empty cell =LEN(A1), it will return 9
then =LEN(B1), it will return 8
click in A1 and you'll see that the cursor will fall just beyond the end of Croupier d/t a space.
take care of that space and your formula will return what you want.

[parbynat]

Sam I will try what you said.
How did you see that there was an extra space at the end, I can't see anything.

[Sam Capricci]

click on cell A1 and put your cursor in the fx bar at the end of the word Croupier and you'll see that the bar | will appear just one space beyond the word like this...
Croupier | space
while doing that in B1 it will appear like this... Croupier| no space.
the LEN formulas I gave you will show that there is something different between both cells, that is big hint that something else is there in one of the cells that isn't in the other.

[parbynat]

Yes I can see that now in the fx bar and also in your LEN formulas that show 9 and 8.
As soon as I backspace once A3 returns 1 as I want.
I have many of these, is there a way of doing a whole column rather than individually?

[Sam Capricci]

you could incorporate a TRIM function to the formula like this... =IF(TRIM(A1)=B1,1,"")
if it is in either you can make it like this... =IF(TRIM(A1)=TRIM(B1),1,"")
if they are all single words w/o spaces you can use find and replace...
find what >> [hit the space bar or copy the space and paste it here]
replace with >> [leave blank]
try once then if you like the results hit replace all and that will take care of it without an adjustment to the formula.
if you don't like the results just hit undo and maybe try the formula change.

[parbynat]

Yes that works.
Many thanks

[Sam Capricci]

You're welcome, AND thank you for the rep!