Good afternoon all. I've got a spreadsheet that I must manually reformat every three months because when I export it from a txt file it comes out pretty unusable.
Columns A-D are fine. Columns E, G, H and J are time, with am/pm formats. The others, columns K-S are hours and minutes. Apparently, in just about all of the columns there are empty spaces that need to be removed. In the time columns I can then do a quick replace and put a space between the last minute and the a or p to put it into the proper time format. Of course I'd use the custom number for this as well.
I was reading about using TRIM, SUBSTITUTE & CLEAN and I think this is what may work, but honestly, bot totally lost with how to do this. Can anyone help? Thanks for looking.
Bookmarks