Thread: How to remove first 12 characters of each cell
View Single Post
 
Old 03-27-2017, 02:25 AM
King Mustard's Avatar
King Mustard King Mustard is offline Windows 8 Office 2013
Member since 2005
  
Join Date: Jun 2014
Location: United Kingdom
Posts: 31
King Mustard is on a distinguished road
Question How to remove first 12 characters of each cell
Excel 2010.

Cell contents:

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

etc. down to A250

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

Is this easily possible?