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!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Burras[/TD]
[TD]10/24/2018[/TD]
[/TR]
[TR]
[TD]Robinson[/TD]
[TD]'2003/00/00[/TD]
[/TR]
[TR]
[TD]Plaintiffs[/TD]
[TD]'2009/00/00[/TD]
[/TR]
[TR]
[TD]Robinson[/TD]
[TD]'2010/00/00[/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Burras[/TD]
[TD]10/24/2018[/TD]
[/TR]
[TR]
[TD]Robinson[/TD]
[TD]'2003/00/00[/TD]
[/TR]
[TR]
[TD]Plaintiffs[/TD]
[TD]'2009/00/00[/TD]
[/TR]
[TR]
[TD]Robinson[/TD]
[TD]'2010/00/00[/TD]
[/TR]
</tbody>[/TABLE]