Forum Discussion
Using Find & Replace Feature
Hello ALL. I need help. I'm having a complete brain lockout. Ok, so some would call it a "Brain Fart", but in my case, "its Bonlde Moment"! lol
Ok, so what I need to do is use the Find & Replace feature in
Microsoft® Excel® for Microsoft 365 MSO (Version 2203 Build 16.0.15028.20218) 64-bit to FIND specific transaction data in a specific column, which in this case the column is titled "Date Paid", and delete everything following the letter "T" as well as the letter "T" in this column. Here is what my spreadsheet looks like. I have done this before at least 50 times, but today I just can not remember how to phrase it in the Find & Replace feature and obviously I'm not phrasing the question correctly in Help either.
Please help!
Any and EVERY Response is sooooooooooooo VERY MUCH APPRECIATED!!
Angel_777_1
1 Reply
Select from V2 down to the last used row.
Press Ctrl+H to activate the Replace dialog.
Click 'Options >>'.
Make sure that the 'Match entire cell contents' check box is clear.
Enter T* in the 'Find what' box, and leave the 'Replace with' box empty.
Click 'Replace All'.
To convert the result to 'real' dates, if Excel doesn't do that automatically:
Click 'Text to Columns' on the Data tab of the ribbon.
Click 'Next >' twice.
Select Date, and select YMD from the drop-down next to it.
Click Finish.
