How to remove first 12 characters of each cell

[King Mustard]

Excel 2010.


Cell contents:


A1 - 24/03/2017 15:56
A2 - 24/03/2017 15:55
A3 - 24/03/2017 15:55
A4 - 24/03/2017 15:54
A5 - 24/03/2017 15:43
A6 - 24/03/2017 13:31


etc. down to A250


I need to remove the first 12 characters and final 3 characters of each cell.


Is this easily possible?

 

[asdfman]

=HOUR(A1) would get you where you need?

 

[philaugust2004]

If you just want to show the time then format cell as Time. Not sure if that is what you are after

 

[Macropod]

Cross-posted at:
How to remove first 12 characters of each cell
https://www.excelforum.com/excel-ge...t-12-characters-of-each-cell.html#post4614923

For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
Please also read:
Excel Forum's Cross-Posting policy in rule #8: Forum Rules
Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html