Extract Date and Time from Instagram Text in MS Excel

Asked Dec 11 '20 at 11:28

Active Dec 11 '20 at 11:49

Viewed 36 times

I'm want to extract date and time from a datetime stamp in excel using formulas from data on Instagram text

The format is such:

2019-10-06T21:14:06.676169+00:00

I would like to have the date and time in separate columns preferably

The date in DDMMYY The Time in HH:MM:SS

I have seen some answers for Python, but is there anything in excel that can get the job done for someone with no knowledge of Python?

edited Dec 11 '20 at 11:49

asked Dec 11 '20 at 11:28

user36176

What is your wanted result exactly? Differenct columns, a change of format etc? This is such a minimal post and even lacks your own attempt. Please have a look at [ask] a question with an [mcve] and edit your post accordingly. – JvdV Dec 11 '20 at 11:33
Apologies I have edited the question – user36176 Dec 11 '20 at 11:49
This works as desired! – user36176 Dec 12 '20 at 04:21

0 Answers0