[Formulawiz]

(R) D LOWE
(R) T LINCECUM

Does anyone know the formula in Excel to get the pitchers name only. leaving out (R), EX:
D LOWE and etc
Thanks

[djiddish98]

=TRIM(RIGHT(A1, LEN(A1)-FIND(") ",A1))) or something like that

[SolidDala]

You can use the MID funtion to remove text form the beginning and just make the MID text part long, like 20-30 char..

=MID(A1;4;20)

Were A1 is the cell the pitcher name is in, 4 is how many char you want to remove starting from left (R)+SPACE is 4, therefor the reference to that specific number. 20 is the length of the mid part, it tells excel to stop input more then 20 char

[Formulawiz]

You can use the MID funtion to remove text form the beginning and just make the MID text part long, like 20-30 char..

=MID(A1;4;20)

Were A1 is the cell the pitcher name is in, 4 is how many char you want to remove starting from left (R)+SPACE is 4, therefor the reference to that specific number. 20 is the length of the mid part, it tells excel to stop input more then 20 char

Thank you for your help. Worked perfectly

[uva3021]

find and replace

"(R)"
""

[SolidDala]

thats even better

[Formulawiz]

find and replace

"(R)"
""

The problem with your solution is every time I download the new pitchers for the day into the sheet I have to use find and replace again, wheras the formula I used does it automatically. Any better ideas.
Thanks