Read a timestamp split by a separator
Turn the text 4-Nov-2026 | 14:30:15 into a real date and time.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(A8,B8) | Takes the date text before the separator. | "4-Nov-2026" |
| 2 | DATEVALUE( … ) | Turns that text into a real date. | November 4, 2026 |
| 3 | TEXTAFTER(A8,B8) | Takes the clock text after the separator. | "14:30:15" |
| 4 | TIMEVALUE( … ) | Turns the clock text into a time and adds it. | … 2:30:15 PM |
Read it left to right. Each pair sits one inside the other, so Excel works from the inside out.
=DATEVALUE(TEXTBEFORE(A8,B8))+TIMEVALUE(TEXTAFTER(A8,B8))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own timestamps. Paste text like 4-Nov-2026 | 14:30:15 into column A of the Template tab and its separator into column B. The dates and times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type the separator exactly as it appears, spaces included. Each row needs it once, with a four-digit year.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Read Unix seconds as a UTC timestamp
Unix seconds 1793802615 → November 4, 2026 2:30:15 PM
Get the template →
Read Unix milliseconds as a timestamp
Unix milliseconds 1793802615000 → November 4, 2026 2:30:15 PM
Get the template →
Read a /Date(…)/ value as a timestamp
/Date(1793802615000)/ → November 4, 2026 2:30:15 PM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →