Power Query to Split a Column

Hi,

I have data in the attached workbook, arranged as a Table, and would like to use Power Query to split the data in column A into three columns with the person's name in one column, the date in the next and the region in the final column.

I have achieved this in Power Query Editor by splitting the column by delimeters (using " / " as the delimiter).

However, when I change the data type of the data in the date column from text to date, most of the dates are converted to "Error"

Can someone please tell me what I'm doing wrong?

Thanks!

Here is the Mcode I used to get the data into three columns formatted correctly. I split on a space and not a "/". Then deleted the two columns holding the slash.

Please Login or Register  to view this content.

Interesting because I get no errors. Here is a short sample of what the results look like for me.

Data Range

	A	B	C
1	Description.1	Description.3	Description.5
2	Carlota	5/5/2016	West
3	Aspen	4/2/2016	South
4	Yanaki	5/2/2016	South
5	FlatTop	4/11/2016	South
6	Carlota	5/21/2016	South
7	Carlota	5/15/2016	East
8	Carlota	5/19/2016	West
9	Yanaki	5/6/2016	East
10	Yanaki	5/7/2016	East
11	Quad	5/20/2016	West
12	Quad	4/29/2016	East
13	Quad	4/18/2016	South
14	FlatTop	4/25/2016	West
15	Yanaki	5/30/2016	South
16	Carlota	5/4/2016	East
17	Carlota	5/18/2016	West
18	FlatTop	4/9/2016	West
19	Quad	5/6/2016	South
20	Quad	5/22/2016	East
21	FlatTop	4/28/2016	West
22	Aspen	5/16/2016	South
23	FlatTop	5/3/2016	East
24	Carlota	4/28/2016	East
25	Aspen	5/18/2016	West

Have checked to see what your regional settings are in PQ? They may be set differently than your Windows Regional settings.

Pleased try

Please Login or Register  to view this content.