creating name and movie title

  • Thread starter Thread starter tans
  • Start date Start date
T

tans

hi, I have A1= D:Asquith, A2=T:Pygmalion, A3=T:French withou
tears,A4=D:A.Bennett,A5=A private function, and I just try to use suc
a formula to create a new column which contains the name of th
director for each row with a film title and a blank for a row with th
director's name but I couldnt do it.Can you help me about this? Th
column B have to be like this,
A
1 D:Asquith

2 T:Pygmalion
3 T:French without tears
4 D:A.Bennett
5 T:A private function
B
1 (empty)
2 Pygmalion
3 French without tears
4 (empty)
5 A private function

(ps.D:director's name, T: film title)
Thanks.
 
Hi
not really sure but try the following in B1
=IF(LEFT(A1,2)="D:","",MID(A1,3,255))
 
2 possibilties.

1. Try this formula in B1

=IF(LEFT(A1,2)="T:",RIGHT(A1,(LEN(A1))-2),"")

and copy it down.

2. Copy column A to column B, then use Find & Replace (CTRL+H) twice on
column B ;

(i) replace D:* with nothing.
(ii) replace T: with nothing.

Rgds,
Andy
 
Back
Top