Dates

Hi Dips, thanks for your query. Separating any string such as a date is called "parsing" and you'll need your Left, Right, Mid and LEN functions to do so if there is no delimiter. If all your dates are 6 digits you could simply use the MID function in three separate cells with the following basic syntax:

=MID(A1, 1, 2)

You use the LEN function when the dates are, say, 6 and 7 characters long and you need to count the string length and, using an IF statement to channel the outcome, chop up the dates in slightly different ways. If you have a live example of this you need help with, feel free to post.

Hope this helps,

Anthony