I know this is going to be obvious to someone out there but I can't figure it out.
I have a spreadsheet with 400 lines and one of the columns is made up of notes. See Below:
"2016 (04/08): Called and spoke to pt. She said she'd try to get us the payment by the end of the month. I told her that was what she said in Feb. I asked if she could send half right away and the rest by the end of the month. she thought she could handle that.
,2016 (02/23): explained that ins has maxed out.
,2016 (02/19): sent letter 1; incl q/stmt $115, ins max
,2016 (01/12): sent q/stmt $115, ins max
,2015 (09/15): PLEASE COLLECT BALANCE OF $15 AT NEXT APPT ON 12-16-15. THANKS! ALL
,2015 (08/20): sent 2nd q/stmt $15, ins paid
,2015 (07/14): sent q/stmt $15, ins paid
,2015 (06/18): DOS 12/09/14. Delta CO asked for additional info. Mailed.
,2015 (05/21): Paul - pt called ins company today and they told her they haven't received any additional information regarding her claim. I see that you resubmitted additional info on 5/14/15 but can you check that they actually have received?
,2015 (05/21): ins havent paid at all suggested that pt calls her ins and just get some info if poss
,2015 (05/15): mailed ins letter
,2015 (05/14): DOS 12/09/14. Delta CO asked for additional information. Mailed.
,2015 (01/30): Statement generated, insurance is still outstanding, sent with note that this statement is only informational.
,2014 (12/09): Patient financed $526.80 through CareCredit (6-Month Interest-Free). CareCredit Fee is 5.9%. CareCredit to pay $495.72 = $526.80 - $31.08 (5.9% Financing Fee).
,2014 (11/25): sent q/stmt $25, ins paid
,2014 (11/13): Bernadette's est pt portion for PRT #11-12 w/ emdo and RTT #22-23 is $501.80 w/ est ins benefit of $691.20; total tx is $1193.00; fees based on Delta PPO fees. JM
,2014 (11/13): Bernadette may be paying with Care Credit; Total amt will be $501.80 - 5.9% = <$29.61> = $472.19; transaction will be processed as a 6 mos interest free loan. JM
,2014 (08/06): call 1 - talked to pt; gave cc # over the phone for $55 balance and asked to have receipt mailed
,2014 (07/22): sent letter 2
,2014 (07/08): sent letter 1 - incl q/stmt $55, deduct
,2014 (06/03): sent q/stmt $55, deduct
,2013 (09/10): Barb, insurance paid better than expected. TX appears pretty comprehensive. Anticipate pt either goes into recall or to be 945'd. Pls refund $262.50, Dr. 3.
,2013 (07/02): Bernadette's est pt portion for PRT (LL) with BG, membrane & emdo #19 & #23 AND for RTT (UR) with irrigation is $1003.50 with est ins benefit of $1237.50; total tx is $2241; fees based on Delta DPO fees vr
,"
I want to delete EVERYTHING in this cell from the first ",2015". I only want to see anything from 2016. So, I want to find ",2015" and replace with _____________________ (Nothing to the end of the cell).
Any help would be greatly appreciated/
I have a spreadsheet with 400 lines and one of the columns is made up of notes. See Below:
"2016 (04/08): Called and spoke to pt. She said she'd try to get us the payment by the end of the month. I told her that was what she said in Feb. I asked if she could send half right away and the rest by the end of the month. she thought she could handle that.
,2016 (02/23): explained that ins has maxed out.
,2016 (02/19): sent letter 1; incl q/stmt $115, ins max
,2016 (01/12): sent q/stmt $115, ins max
,2015 (09/15): PLEASE COLLECT BALANCE OF $15 AT NEXT APPT ON 12-16-15. THANKS! ALL
,2015 (08/20): sent 2nd q/stmt $15, ins paid
,2015 (07/14): sent q/stmt $15, ins paid
,2015 (06/18): DOS 12/09/14. Delta CO asked for additional info. Mailed.
,2015 (05/21): Paul - pt called ins company today and they told her they haven't received any additional information regarding her claim. I see that you resubmitted additional info on 5/14/15 but can you check that they actually have received?
,2015 (05/21): ins havent paid at all suggested that pt calls her ins and just get some info if poss
,2015 (05/15): mailed ins letter
,2015 (05/14): DOS 12/09/14. Delta CO asked for additional information. Mailed.
,2015 (01/30): Statement generated, insurance is still outstanding, sent with note that this statement is only informational.
,2014 (12/09): Patient financed $526.80 through CareCredit (6-Month Interest-Free). CareCredit Fee is 5.9%. CareCredit to pay $495.72 = $526.80 - $31.08 (5.9% Financing Fee).
,2014 (11/25): sent q/stmt $25, ins paid
,2014 (11/13): Bernadette's est pt portion for PRT #11-12 w/ emdo and RTT #22-23 is $501.80 w/ est ins benefit of $691.20; total tx is $1193.00; fees based on Delta PPO fees. JM
,2014 (11/13): Bernadette may be paying with Care Credit; Total amt will be $501.80 - 5.9% = <$29.61> = $472.19; transaction will be processed as a 6 mos interest free loan. JM
,2014 (08/06): call 1 - talked to pt; gave cc # over the phone for $55 balance and asked to have receipt mailed
,2014 (07/22): sent letter 2
,2014 (07/08): sent letter 1 - incl q/stmt $55, deduct
,2014 (06/03): sent q/stmt $55, deduct
,2013 (09/10): Barb, insurance paid better than expected. TX appears pretty comprehensive. Anticipate pt either goes into recall or to be 945'd. Pls refund $262.50, Dr. 3.
,2013 (07/02): Bernadette's est pt portion for PRT (LL) with BG, membrane & emdo #19 & #23 AND for RTT (UR) with irrigation is $1003.50 with est ins benefit of $1237.50; total tx is $2241; fees based on Delta DPO fees vr
,"
I want to delete EVERYTHING in this cell from the first ",2015". I only want to see anything from 2016. So, I want to find ",2015" and replace with _____________________ (Nothing to the end of the cell).
Any help would be greatly appreciated/
