dear all,
I am new to VBA and i am currently need to have a macros to populat
unique entries into an txt file.

Spreasheet (A1 column)
-----------
aaaaa_1
aaaaa_2
bbbbb_1
ccccc_3
ccccc_1

i wish to populate the above datas into a txt file with this result:

result.txt
--------
aaaaa
bbbbb
ccccc

Can anyone help on this

--
ymeya
-----------------------------------------------------------------------
ymeyaw's Profile: http://www.excelforum.com/member.php...fo&userid=3442
View this thread: http://www.excelforum.com/showthread.php?threadid=54235