| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperate info in a cell
Hi,
In cell A1 I have the following information: Fri 30 Oct 09:11 What I would like to do, via a macro I imagine, is to delete the month and to seprate out the time into cell B1, so I would end up with: Cell A1 - Fri 30 Cell B1 - 09:11 Any suggestions as to how I should achieve this would be much appreciated -- Cheers Peter (Reply to address is a spam trap - pse reply to the group) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to move all info in column a to seperate columns | Excel Discussion (Misc queries) | |||
| Fill a seperate cell with info depending on the input in another c | Excel Discussion (Misc queries) | |||
| HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS? | Excel Worksheet Functions | |||
| filtered info can be copied (extracted) to seperate sheet | Excel Discussion (Misc queries) | |||
| How do I link info from 2 seperate documents at same time. | New Users to Excel | |||
![Petert[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
