How can I use a formula on a column containing text?

[viv1]

I have a sheet with the ages of patients written with some ages written in years and some in months, i wanted to make it uniform and convert any ages written in months to years by dividing those cells by 12 to get the year in decimals.

however when i use a formula dividing that cell by 12 it shows up as an error before the word 'month' is in that cell.
is there a way around this without manually deleting the word 'month' from each cell?

i've attached an example to show what i mean

 

[Rick Rothstein]

When the age is written in years, is there any text in the cell with the number? If so, show us some examples of what they would look like.

 

[hajiali]

Try this for cells with months. You will need to chand the format. As Rich mentioned to better understand your request post some examples instead of images

=LEFT(A3,SEARCH(" ",A3)-1)/12