Replace Module, Replace with blank

Hi, I wanted the program to remove all the 0:00 in a date column.

Example
2/3/2021 0:00
5/3/2021 0:00

I put in what I wanted to replace. It wouldn’t let me replace it unless I put something in the “with” box. Is there any way to do a find and replace leaving the replace blank.

Thanks
Kim

@Kim

You can just leave With empty to remove the Replace term.

The more I messed with it, the more I think it was the date form issues which I could reform in excel.

1 Like