Hello everyone,
I have a column that is in bad shape. It is full of alpha numeric text, including a date. (e.g. 63 Fed. Reg. 47319 (Sept. 4, 1998)). I can't count on the size of the cell always being the same, nor that the date is displayed as shown above in parentheses. Occasionally, the dates are displayed like this (3/9/95). I need to create a new column that contains the year. I fully expect that I may need to run a couple of different formulas to gather the 4 digit years and the 2 digit years. Any ideas on how to do this?
Thanks in advance.
Rob
Bookmarks