title: How do I extract a year from a text string and return the year in another column?
body: <p>I have a list of work orders in column A that contain a year. Below is a picture of some of the work orders in the list:</p>
  
  <p><a href="https://i.stack.imgur.com/HKzZv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HKzZv.png" alt="enter image description here"></a></p>
  
  <p>Goal: I would like to know how to create a function in VBA that extracts the year from the work orders in column A, and return the corresponding year in column B, like shown in the picture below:</p>
  
  <p><a href="https://i.stack.imgur.com/YG0WI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YG0WI.png" alt="enter image description here"></a></p>
  
  <p>I can enter the year manually by looking in column A, but I was wondering if there is a function that can do this task automatically.</p>