maybe a formula like this. Then copy/paste values. Or use a macro to do the
same for all.
=right(a1,1)& " having "& b1

--
Don Guillett
SalesAid Software

"ymeyaw" wrote in
message ...

dear all,

i had spreadsheet which look like this:
ID info
-- ---
KAS_1 123
KAS_2 345
TAS_2 111

i wish to have a macro which can search through the ID column and group
those with same left 3 characters of ID into one txt file.

example of the content of txt files which i prefer:

KAS.txt
-------
1 having 123
2 having 345


(1,2 here is the character after the underscore of ID)

TAS.txt
-------
2 having 111
(2 here is the character after the underscore of ID)


can anyone help me on this?Thousand thanks


--
ymeyaw
------------------------------------------------------------------------
ymeyaw's Profile:
http://www.excelforum.com/member.php...o&userid=34421
View this thread: http://www.excelforum.com/showthread...hreadid=541920