Greetings,

I have searched hi & lo for any help on this, but drawn a blank so far.

I have data which I have combined from 2 cells to 1 cell. {see Example1}

{Example1}

ColA: ColB:
Hardware Vendor

Cisco Cisco 1700

I have used the text formula =A2&" "&B2, so come up with...

"Cisco Cisco 1700" in ColB

The catch is, sometime the Hardware in Col A is formatted correctly, so the
text string works correctly. see {Example2}

Example2

ColA: ColB:
HP\Compaq DL 585 G1

this returns

"HP\Compaq DL 585 G1", which is perfect.

I have near on 400 cells, 50% of which are in the incorrect format..so the
Vendor name is appearing twice.

Need to identify there duplications and split them out.

Any ideas would be much appreciated.

To change the way I receive the original data, would be an insurmountable
challenge.

This is how I receive the data.

Source:
Several Thousand Records on a sheet, many, many duplications.
Pivot Table created to reduce duplications to single instances

One I receive Data:
Formula used to extract from Pivot Table is simple, =A, =B
Then =A2&" "&B2 used to get the list with lots of duplications


Thanks for taking the time to read this,

Regards

TerryH