Truncation problem

[nnadimi19]

Good Morning;

I have the following rows:

Annie Pledger vs. Baptist Hospital
Ricardo Martinez, individually and as next friend of Ricardo Martinez, Jr. and Natividad Lujan, as temporary administrator of the Estate of Maria De La Luz Martinez vs. Germinal Nunez, M.D., Pedro A. Ortega, M.D., Tracie M. Kelley, R.N., Junita Gomes, L.V.N., Herminia Lopez, L.V.N. and Yseleta General Hospital, a corporation, jointly and severally
Guillermo Alvidrez vs. St. Joseph Hospital of El Paso, Texas, a non-profit corporation
Virginia A. Wilson vs. Haltom General Hospital and T&R Clinic, a professional association
Mary Dorothy Griffin vs. Medina Memorial Hospital


when I use the following command"=RIGHT(A2,FIND(" vs. ",A2)) I get the following result :
tist Hospital
M.D., Pedro A. Ortega, M.D., Tracie M. Kelley, R.N., Junita Gomes, L.V.N., Herminia Lopez, L.V.N. and Yseleta General Hospital, a corporation, jointly and severally
profit corporation
sional association
na Memorial Hospital
If you notice the first few characters after the 'vs." is missing. How do I go about fixing this problem.

 

[TommyGun]

The FIND command will find where the text starts. Therefore, you are not returning enough data. Try this...

=RIGHT(A2,FIND(" vs. ",A2)+5)

 

[Chitosunday]

You did'nt mention what you are trying to do when you made the formula =right(a2,find("vs"... . Did you put it in all the row of each line?

 

[nnadimi19]

Tommygun;

Will I have to change the +5 to different number based on each row????? or is there a way to make it genaric.

 

[TommyGun]

5 is the number of characters in " vs. " so it will not need to be adjusted.

 

[nnadimi19]

Thnaks

 

[Andrew Poulsom]

The FIND command will find where the text starts. Therefore, you are not returning enough data. Try this...

=RIGHT(A2,FIND(" vs. ",A2)+5)

I think it should be:

=RIGHT(A2,LEN(A2)-FIND(" vs. ",A2)-4)