Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcard characters with time
I get an Excel spreadsheet with 5K race times that look like this:
18:29.3 18:29.7 I need to change them to look like this: 0:18:29 0:18:29 I have tried the find with this: ([0-9]{2}):([0-9]{2}).([0-9]) thinking I could then use a replace like this: 0:\1:\2 However, the find always comes back that no cells meet this criteria. I have also tried a find with **:**.* and nothing is found. If this approach worked, what would the replace string be? I get hundreds of these times and an automated way of changing them would be very helpful. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard characters, IF functions | Excel Worksheet Functions | |||
wildcard characters | Excel Discussion (Misc queries) | |||
HELP: Wildcard Characters | Excel Discussion (Misc queries) | |||
WildCard Characters | Excel Worksheet Functions | |||
Using Wildcard characters in sumproduct | Excel Worksheet Functions |