Uploaded February 2015 | Updated September 2026, 56 minutes ago

---

Get Excel file 00150 here: http://1drv.ms/1bYwrTa
Imagine a date and time value chopped up and surrounded by text in a single cell.
You need to increase this date-time by a variable (added time) while at the same time keeping all of the text in the same position.
See how I tackle this challenge in 6 steps.

Read my blog post here:
myspreadsheetlab.com/video-00121_crazy-string-manipulation

twitter.com/KevinLehrbass
myspreadsheetlab.com