how do I separate the two values in column A to two separate

how do I separate the two values in column A to two separate columns in excel?

D11 15,333.33 2 15.02.329.167 3 15.04.287.5 4 15.06.266.667 5 15.08, 312.5 6 15.1.291.667 7 15.12.270.833 8 15.14.283.333 9 15.16.270.833 10 15.18.316.667 11 152,275 12 15.22, 320.833 13 15.24, 270.833 14 15.26,275 15 15.28, 312.5 16 15 262.5 17 15.32.279.167 18 15.34, 266.667 19 15.36.229.167 20 15.38.270.833 21 15.4.308.333 22 15.42, 270.833 23 15.44, 291.667 24 15.46.287.5 25 15.48.333.333 26 15.5.308.333 27 15.52, 325 28 15.54,375 29 15.56, 304.167 30 15.58.295.833 31 15.6, 295.833 32 15.62,325 33 15.64, 354.167 34 15.66.308.333

Solution

Answer:

The steps which must be performed to separate the two values in column A to two separate columns in excel are given as below :

If required insert empty columns to the right side of the cells we need to convert into two separate columns.

Choose the cells we required or need to convert.

Now click on the Text to Columns button which appears in the Data Tools group on the Data tab.

Choose the Original Data type which is compatible or feasible with our data which already exists.

Finally click on Next.