I have two files in excel that I need to compare cell for cell. Right now I open them as csv's in BC3 and compare the two. BC3 colors red in each file what is missing in the other file. But that's not quite what I'm hoping to get. I want to create a third file that shows the changes to file A made in file B.
Here is what I'm looking for:
File A
------
The cow is brown
File B
------
The cowgirl is named brandy
File C (output from BC3 or BC3 in tandem with some other techniques)
------
The cowgirl is brown named brownandy
(I wanted to make the red strikethough, but didn't know how here. Anyway, that's a tiny detail and isn't the gist of my question)
Any help would be appreciated. Thanks.
Here is what I'm looking for:
File A
------
The cow is brown
File B
------
The cowgirl is named brandy
File C (output from BC3 or BC3 in tandem with some other techniques)
------
The cowgirl is brown named brownandy
(I wanted to make the red strikethough, but didn't know how here. Anyway, that's a tiny detail and isn't the gist of my question)
Any help would be appreciated. Thanks.
Comment