changing the cell information #2

Hi I have files I tried to change the cell information to another cel
that have to be the blank for a row that contains director name in cel
A and for the movie titles I have to have director names instead of th
title names.Please help me, the data in cell B sholuld have to be,

A
1 D:B.Jane
2 T:Back to the future
3 T:Aliens
4 T:X-files
5 D:Adam Mathew
6 T:Core
7 T:Titanic
B
1 (empty)
2 D:B.Jane
3 D:B.Jane
4 D:B.Jane
5 (empty)
6 D:Adam Mathew
7 D:Adam Mathew

thanks

--
Message posted from http://www.ExcelForum.com

0
4/7/2004 2:08:20 AM
excel 39879 articles. 2 followers. Follow

0 Replies
467 Views

Similar Articles

[PageSpeed] 51

Reply:

Similar Artilces: