Smart inserting od colons

[Vester]

I have a column of minutes/seconds stamps, but without a colon, ie. 1245 [as 12:45] or 4555 [as 45: 55]. Is there a shortcut method of inserting the colon between the 2nd and 3rd digits?

 

[macropod]

You could do that with a fairly simple wildcard Find/Replace, where:
Find = <([0-9]{1,2})([0-9]{2})>
Replace = \1:\2
If you have other 3-4 digit numbers (e.g. years, numbers with thousands separators), I recommend not using ReplaceAll.

 

[Vester]

You could do that with a fairly simple wildcard Find/Replace, where:
Find = <([0-9]{1,2})([0-9]{2})>
Replace = \1:\2
If you have other 3-4 digit numbers (e.g. years, numbers with thousands separators), I recommend not using ReplaceAll.

Thanks! Can you tell me, is there any book to learn such tricks?

 

[macropod]

I'm not sure about any books, but you could check out https://wordmvp.com/FAQs/General/UsingWildcards.htm