VBA to remove the blank space in the cell

[saranyabi]

Hi buddies,

i would like to have a script as follows

i have a n number of cells in column A

each cell contains some data as attached file.. now i need to do the following

step1: remove the space in the end of the string in each row

for example

abi, sara;bali, Joe

in the above data theres is space after the string Joe... i need to remove that

step2:

arange them in descending order

step3:

remove duplicates in the column A

could u please assist with me on this as i am new to VBA

[jindon]

each cell contains some data as attached file

Where did you attach?

[saranyabi]

sample data.xlsxHi Jindon,

i have attached a sample data .. please have a look.. thanks a lot..

[Olly]

Try:

Please Login or Register  to view this content.

Adapt to suit.

[jindon]

Order in result is bit different, but it is follwing the logic you described.

Please Login or Register  to view this content.