|
|
#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. |
|
|
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 7 64bit 
Office 2010 64bit
Threaded Mode