zeekmcphee
New Member
- Joined
- Feb 27, 2018
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
hello,
In column A I have a couple of hundred cells with data ,there are no blank cells,The text is layed out like this
monday 12:55 february.
with days of the week,times and month varying....
I am looking for a way to keep monday in ColA,the time in ColB and the month in ColC,then loop down the entire column to the end.
Either vba or a formula solution would help.The only constant in the text is the time which is always 4 letters long(five including the :
hope this makes sense.Any ideas much appreciated
thanks
zeekmcphee
In column A I have a couple of hundred cells with data ,there are no blank cells,The text is layed out like this
monday 12:55 february.
with days of the week,times and month varying....
I am looking for a way to keep monday in ColA,the time in ColB and the month in ColC,then loop down the entire column to the end.
Either vba or a formula solution would help.The only constant in the text is the time which is always 4 letters long(five including the :
hope this makes sense.Any ideas much appreciated
thanks
zeekmcphee