Help Removing Time Stamps

Occasional Visitor

I need help removing this odd time stamp from my dates.  There is no space between the formatted date and time.

 

Example:

2022-03-09T10:00:00:00Z

1 Reply

@Joe_TaylorSolarJT Try Text-to-columns, with "T" as the delimiter. In step 3, set the data type for the first column to YMD and the second column to Skip. If all goes well you'll end up with one column of properly formatted dates.