Macro to remove a duplicate, character, and add a hyperlink

[wizmaster]

Hi All -

I have excel 2010, and had a question. I have a spreadsheet that is an export from sharepoint. One of the columns yeilds data back like

"756;#756;#757;#757". What i want to do is that for only for that specific column, i want the macro to remove the duplicates, and the "#",

So the output would be "756;757" .

Is this possible?

[mike7952]

You can not have 2 hyperlinks in 1 cell.

[wizmaster]

oh got it. thank you for the clarification! i can remove the the hyperlink part of the request

[mike7952]

This will work. Change A for your column and 2 for your starting row

Please Login or Register  to view this content.

[wizmaster]

Thank you! This works great!