You're quite welcome, and thanks for the feedback.

And you're right, it's very handy..........I use it all the time.

Vaya con Dios,
Chuck, CABGx3



"Chia" wrote:

Thanks, Chuck. ASAP is a very powerful tool. It would have saved me a lot of
time if I have started to use it in the first place.
Thank you so much!^_^

"CLR" wrote:

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do just that........

Vaya con Dios,
Chuck, CABGx3



"Chia" wrote:

Hi,
I have data like the followings:

A B C
1 DrugA Preclinical I 5/3/03
Preclinical II 5/5/05
PC III 5/5/06
2 DrugB Preclinical III 4/3/03
Phase II 9/5/05
PC III 1/5/06

The information under B is seperated by square(alt+0101). How can I get the
list like

A B C
1 DrugA Preclinical I 5/3/03
2 DrugA Preclinical II 5/5/05
3 DrugA PC III 5/5/06
4 DrugB Preclinical III 4/3/03
5 DrugB Phase II 9/5/05
6 DrugB PC III 1/5/06

Thanks!