Bringing partial data from one cell into another
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
|