Hi All,
this is driving me mad.
I have a column of dates format 01/06/2018 for example. I want to separate them into individual columns. when I use Text to Columns they get separated into this
01/06/2018 from this to this below. three columns
<tbody>
</tbody>
Columns to text many times and have tried formatting the column all to no avail.
Any ideas chaps?
Phil
this is driving me mad.
I have a column of dates format 01/06/2018 for example. I want to separate them into individual columns. when I use Text to Columns they get separated into this
01/06/2018 from this to this below. three columns
Jan | 06-Jan-00 | 10-Jul-05 |
<tbody>
</tbody>
Columns to text many times and have tried formatting the column all to no avail.
Any ideas chaps?
Phil