How to remove extra space from date column?

I have imported a text file in fixed width file format.

There are 3 columns of date. Right now they are in string data type.

Dates follow: mon dd YYYY format

Jul 13 2022 example

Now If the date is just single digit, there is extra space in between date and month...

Like: Aug 5 2021

How to remove this extra space if date is single digit. And convert this into date format so that no readability issues come with that space.

Thanks

Help

Accepted answers

Hey @Isha_Gupta just use a data cleansing tool like so:

Use a Date Time tool with Custom configuration of..... Mon d yyyy

Hi @Isha_Gupta , using the DateTimeParse formula can put this into a date format (and data type) for you:

Hope this helps!

Hey @Isha_Gupta just use a data cleansing tool like so: