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
Bookmarks