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.
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.