abarbee314
New Member
- Joined
- Apr 5, 2013
- Messages
- 24
Helping our resource center with a crazy project: an attorney has a table of data where 40% of the date values are like this "2003/00/00" and the rest are US-correct (03/15/2019). This one is hurting my brain, but I can't figure out how to (a) re-arrange the values and (b) get it to sort right amongst the other 2003 values. Or can it?
Bonus bugger: there are several instances where the "2003/00/00" values (again, an example) are preceded by an apostrophe for some reason. Deleted one of them 8 times and it never goes away. Tried some weird paste values + Add from a blank cell trick, didn't work. Tried text-to-columns with apostrophe as the delimiter (the wizard doesn't see it).
Any help would be certainly appreciated! Very sample provided below
Thanks!
<tbody>
</tbody>
Bonus bugger: there are several instances where the "2003/00/00" values (again, an example) are preceded by an apostrophe for some reason. Deleted one of them 8 times and it never goes away. Tried some weird paste values + Add from a blank cell trick, didn't work. Tried text-to-columns with apostrophe as the delimiter (the wizard doesn't see it).
Any help would be certainly appreciated! Very sample provided below
Thanks!
Name | Date |
Burras | 10/24/2018 |
Robinson | '2003/00/00 |
Plaintiffs | '2009/00/00 |
Robinson | '2010/00/00 |
<tbody>
</tbody>