I need a macro to search a bank of cells in a document and replace 00s00 with 00.00s - this is only an example and could be anytime in the 24 hour clock - the letters may also be different, but only a few options, normally s or x
I have attached an example file for reference - columns C and F have these times in, but as you will see there are others listed without letters.
Admin - Hope this listing is okay, as already looked at this in Formulas.
Many thanks for any help
Bookmarks