|
|
#1
03-27-2017, 02:25 AM
|
||||
|
||||
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? |
|
#2
03-27-2017, 09:20 AM
|
|||
|
|||
Are these cells formatted as text or are they time values with a time format? If you attach your workbook, I can tell easily.
In the first case, you can extract the portion you want to another cell using a mid function: =mid(a1,12,5) The second case is much easier. All you need to do is reformat the data. |
|
#3
03-28-2017, 04:55 AM
|
|||
|
|||
|
|
|
#4
04-07-2017, 12:06 AM
|
||||
|
||||
|
Cross-posted at:
https://www.mrexcel.com/forum/excel-...ml#post4788363 https://www.excelforum.com/excel-gen...ml#post4614923 For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 Please also read: Excel Forum's Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-a...rum-rules.html Thread closed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I remove spaces between only Chinese characters? | sivartnosredna7 | Word | 2 | 01-09-2017 05:33 AM |
 How do I Remove A Specific Amount of Characters from Lines in a Document?
|
tatihulot | Word | 5 | 01-22-2016 05:55 AM |
|
Removing characters from a cell
|
tonydoneese | Excel | 4 | 01-12-2016 07:41 AM |
|
Word VBA: Cannot Edit Range (Delete characters except the first in a table cell)
|
tinfanide | Word VBA | 3 | 04-27-2012 09:48 AM |
| How to remove these unknown characters appearing | rajpes | Word | 1 | 03-02-2012 03:24 AM |
Windows 8 
Office 2013
Linear Mode
