TheUnconquered
New Member
- Joined
- May 9, 2013
- Messages
- 29
- Office Version
- 2021
- Platform
- Windows
Hello,
I'm trying to use =RIGHT and =LEFT formulas to pull data out of a single cell. A column has dates and times all included together in one cell. For example, 1/2/2018 9:00:00 AM is all in one cell and I want to separate it into two cells. One with the date and one with the time. I'm trying to use the =RIGHT and =LEFT formulas to do this, which seems simple enough, but I'm getting a weird output (43102 for the example above). I've tried to format the cells as dates or times, etc. and it's not working. Any idea of what might be causing this? I'm not sure if it's a formula problem, a formatting problem, or maybe there's a better way to do this...
Thanks,
Blake
I'm trying to use =RIGHT and =LEFT formulas to pull data out of a single cell. A column has dates and times all included together in one cell. For example, 1/2/2018 9:00:00 AM is all in one cell and I want to separate it into two cells. One with the date and one with the time. I'm trying to use the =RIGHT and =LEFT formulas to do this, which seems simple enough, but I'm getting a weird output (43102 for the example above). I've tried to format the cells as dates or times, etc. and it's not working. Any idea of what might be causing this? I'm not sure if it's a formula problem, a formatting problem, or maybe there's a better way to do this...
1/2/2018 9:00 | 43102.375 |
Thanks,
Blake