Hello - Trying to come up with formula that will give me the number from a different cell, but the cell I am trying to reference also had letters,
Example: The cell referenced, lets call it A1, contains: '4 yrs'. I would like cell A2 to calculate 4. I tried doing a =LEFT(A1,1), but the issue I...