Comparing Data in Excel

P

Pree

No, I did see this link. It seems these instructions are for whe
you're looking at one column of data only. I've tried to manipulat
the formula to include two columns but I've been unsuccessful a
getting a formula that works
 
D

Dave Peterson

You can concatenate cells with a formula like:

=a1&b1

But I'd use a separator between those cells so you don't have to worry about two
concatenated strings looking the same--but the separate cells are different:

abcd efgh
and
abcdef gh

would look like:
abcdefgh (in both cases).

Something like:
=a1&"---"&b1
or
=a1&char(10)&b1

But use a unique string that doesn't occur in either column.

Then copy this formula down the column.
 
Top