LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcard characters, IF functions PMBO Excel Worksheet Functions 1 November 15th 06 04:54 PM
wildcard characters Hasty Excel Discussion (Misc queries) 2 July 21st 06 10:40 AM
HELP: Wildcard Characters bbddvv Excel Discussion (Misc queries) 0 June 28th 06 02:38 PM
WildCard Characters Ralph Heidecke Excel Worksheet Functions 1 June 1st 06 07:43 PM
Using Wildcard characters in sumproduct Charles Excel Worksheet Functions 3 July 22nd 05 05:23 AM


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"