Column A and Column B....... Delete all values in Column B from Column A and end result in Column C

[pateln1594]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1111[/TD]
[TD]6666[/TD]
[TD]1111[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2222[/TD]
[TD]8888[/TD]
[TD]2222[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3333[/TD]
[TD][/TD]
[TD]4444[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4444[/TD]
[TD][/TD]
[TD]5555[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5555[/TD]
[TD][/TD]
[TD]7777[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6666[/TD]
[TD]1010[/TD]
[TD]9999[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7777[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]8888[/TD]
[TD]3333[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9999[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1010[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have 3 columns as shown above. I want to get rid of all the values in Column B from Column A and get the result in Column C. I want to do this using a formula not excel VBA. Please help I tried using Vlookup and replace but it's not working properly.