Forum Discussion
Change date format
Hi all! I want to change a bunch of dates that look like the below into a simple 'Nov-16' format. How do I do this?
Hi Edward,
You have some texts which can't be changed just by formatting, you need to transform your texts. It could be several ways, perhaps the easiest one is to use Flash Fill - type manually in next to the right columns texts as you desire to see it, e.g.
7-Nov-16 - 13-Nov-16
After the couple of cells Flash Fill will suggest to fill the column till end, press Enter. Or select cells at this at new column starting from ones you have texts till end of the range and Home->Fill-Flash Fill.
Otherwise you may generate you texts from scratch in any format adding week number as helper column; or split your column on two by Data->Text to columns and combined back with desired format; or parse the text and combine parts with desired format.