Forum Discussion
Solved
Function opposite to CONCATENATE?
I have a large spreadsheet that shows the date and time in one cell. I would like to separate the date from the time into two cells. I am familiar with the CONCATENATE function, and what I need would do the opposite.
This is an example of what the contents of the cell contains: 2017-01-03T08:10:37-08:00
I would like to split it into two cells: 1) 2017-01-03 and 2) 08:10:37-08:00. The "T" is irrelevant... it can be removed later if needed.
Is there a function that can do this for me?
Thanks
Elaine
Hello Madison
Use Text-to-columns.
Or Flash fill.
5 Replies
- If the data is variable, then the result can be achieved using MID.
Do let me know if this is required.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, IndiaYah, Excel is infinite... Any result could be achieved by few different ways.
Hi Madison,
Select that column, Go to Data -> Select Text to Column -> Fixed Width (split data below as you want) -> Click Next, Next, Finish
Done.
Hello Madison
Use Text-to-columns.
Or Flash fill.
Text to columns did the job. Thank you very much!
