Using find and replace for a specific purpose

[src1921]

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/

 

[FDibbins]

Apply filters
filter on "contains 2015
check to make sure that is what you want
delete what shows

 

[FDibbins]

hmmm either that, or just filter to SHOW only 2016, that way you can keep all your data

 

[My Aswer Is This]

So if row(1) column(A) has the value "2015" any place in the cell.
Do you want to delete the whole row or clear the cell or entire row?

 

[src1921]

So if row(1) column(A) has the value "2015" any place in the cell.
Do you want to delete the whole row or clear the cell or entire row?

First, I need you to know that this feature (aside from a simple find and replace) is new to me. I've used it but it's been 2 years and I've forgotten a lot of it.

What I want to do is delete everything on the line that show the first 2015 PLUS every line to the end of the cell (Prior years included).

If you have an answer, can you please tell me exactly how it needs to read and where I put that language? I need the very basics. If you could help, it would be great!

 

[My Aswer Is This]

You said quote:
I have a spreadsheet with 400 lines and one of the columns is made up of notes. See Below

You did not say what column?

And I asked the question:

So if row(1) column(A) has the value "2015" any place in the cell.
Do you want to delete the whole row or clear the cell or entire row?

You did not answer my question.

 

[src1921]

You said quote:
I have a spreadsheet with 400 lines and one of the columns is made up of notes. See Below

You did not say what column?

And I asked the question:

So if row(1) column(A) has the value "2015" any place in the cell.
Do you want to delete the whole row or clear the cell or entire row?

You did not answer my question.

I do think I steered you the wrong way. I have a spreadsheet but only want to delete data in a single column. Each line of this column is a different patient and there are notes going back to 2004 for some of them. I want to delete everything prior to 2016. The way I think of it is that if I can tell it to find 2015 and then delete that and everything after that to the end of the cell, I think that would do it. I don't understand what a value is. I'm sorry.

 

[My Aswer Is This]

OK. I understand now.
You have numerous lines of text in one cell. Sort of like using a cell as a small NotePad.
Solving your question is now beyond my Knowledgebase
Hopefully someone else here at Mr. Excel will be able to help you.

 

[skywriter]

Try this on a copy of your data, it assumes the text to be replaced is in column A.

If this is not he case change the column letter, but leave the quotes around the letter.

Sub ReplaceNotes()
    With ActiveSheet.Columns("A")
        .Replace What:="2015*", Replacement:="", LookAt:=xlPart
    End With
End Sub

 

[src1921]

OK. I understand now.
You have numerous lines of text in one cell. Sort of like using a cell as a small NotePad.
Solving your question is now beyond my Knowledgebase
Hopefully someone else here at Mr. Excel will be able to help you.

Thank you SO much for trying!