# The Wiert Corner – irregular stream of stuff

• ## Email Subscription

Join 2,856 other followers

# Archive for January 9th, 2017

## If anyone ever wants to have a batch of LTE dumb phones built…

Posted by jpluimers on 2017/01/09

If anyone ever wants to have a batch of LTE dumb phones built:

I’m not aware of simple-voice-only phones with LTE modem. From my former life at a telephone producer i remember costs to get a platform running and the effort spend on special editions, i’d say if you are willing to buy 50000 we could find someone producing this for you. In China. But as written above, a basic-2G service (for M2M and emergency signalling or calls) will stay for long.

–jeroen

## How I remember the German word “Urheberrecht”

Posted by jpluimers on 2017/01/09

Los, heb die Uhr auf. Habe ich das Urheberrecht oder du?

I’m partially word-blind and an learn by association.

So thanks to the below links, I can now remember Urheberrecht:

It’s about Ur, Heber and Recht.

–jeroen

## Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted by jpluimers on 2017/01/09

To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2:

Meaning: Date1Text Date1Value Column: Formula: Explanation: I =TEXT(C2,”dd/mm/yyyy”) Interpret date text of the original text no matter the Excel settings J =DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) Encode the date text to an actual date: dd#mm#yyyy format where # is any separator K =J2=L2 Are the encoded dates equal? L =DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2)) Encode the date text to an actual date: mm#dd#yyyy format where # is any separator M =TEXT(N2,”mm/dd/yyyy”) Interpret date text of the original text no matter the Excel settings

Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.