i have my data in A3:A7
HD-01-01
SP-126-01
HD-02-05
CD-80-04
GD-1000-01
and B3:B7
10000
20000
30000
40000
50000
i want take any char between -*-
--
lunar_star
------------------------------------------------------------------------
lunar_star's Profile:
http://www.excelforum.com/member.php...o&userid=36882
View this thread:
http://www.excelforum.com/showthread...hreadid=565978