[Stefan]

RAM wrote:
taking a column of dates (100,000s rows) like:
20110905

and separating the Y M and D using tabs, to result in:
2011 09 05

Or use an RegEx search&replace like

	Find: (d{4})(d{2})(d{2})

	Replace with: $1t$2t$3

	[X] Use Regular Expressions

	

BTW: that way you can even reorder the YMD sequence.