So I have a spreadsheet that has in each cell a code that looks like the following "NYL5". What I want to do is take the 4th character in this code with is always number and add them all together in a column and then calculate the average. Is this possible at all? If so can you tell me how?

Thanks,

stuck

Yup its possible

Try something like this to get the 4th character
=INT((RIGHT(LEFT(A1,4),1)))

Then just use the average function

All the best
Dave