Hello, I need a better way (rather than indivdually) to add a space before PM or AM in a cell range that looks like this:
04:06PM
04:19PM
04:32PM
08:42PM
11:00AM
12:01PM
06:13AM
09:35PM
06:18AM
09:00PM
12:34PM
12:37PM
07:22AM
In other words a space before the last two letters of every cell in colum C
Thanks
Bookmarks