Bringing partial data from one cell into another

J

Jack Taylor

I believe that there is a way to bring part of the data
from one cell into another, but I sure can't find the
correct function to make this happen. For example:

"year 2005" is contained within cell A1 and I would like
to bring only "2005" into cell B3.

Does anyone know the formula to make this happen?

Thanks!
JT
 
D

Duke Carey

Is it ONLY and ALWAYS the last four characters?

=RIGHT(cell address, 4) or =VALUE(RIGHT( cell address,4))
 
Top