The data listed below is all in column A. Based on the data in the parentheses, I want a return of Monthly, BW or Hospital in column B. Other than doing a text to column or sorting and manually typing in Monthly, BW or Hospital, is there anything else I can do to get my desired results?
Excel is attached.
Thanks for your help!
Period
02/01/2014 - 02/28/2014 (Monthly Payroll)
02/01/2014 - 02/28/2014 (Monthly Payroll)
01/30/2014 - 02/12/2014 (University Bi-Weekly (Thu - Wed))
01/16/2014 - 01/29/2014 (University Bi-Weekly (Thu - Wed))
02/01/2014 - 02/28/2014 (Monthly Payroll)
02/01/2014 - 02/28/2014 (Monthly Payroll)
02/01/2014 - 02/28/2014 (Monthly Payroll)
01/30/2014 - 02/12/2014 (University Bi-Weekly (Thu - Wed))
01/16/2014 - 01/29/2014 (University Bi-Weekly (Thu - Wed))
02/01/2014 - 02/28/2014 (Monthly Payroll)
02/01/2014 - 02/28/2014 (Monthly Payroll)
02/09/2014 - 02/22/2014 (Hospital Bi-Weekly (Sun - Sat))
01/26/2014 - 02/08/2014 (Hospital Bi-Weekly (Sun - Sat))
01/30/2014 - 02/12/2014 (University Bi-Weekly (Thu - Wed))
01/16/2014 - 01/29/2014 (University Bi-Weekly (Thu - Wed))
Bookmarks