Forum Discussion
Madison Lader
May 05, 2017Copper Contributor
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 wou...
- May 05, 2017
Hello Madison
Use Text-to-columns.
Or Flash fill.
Detlef_Lewin
May 05, 2017Silver Contributor
Hello Madison
Use Text-to-columns.
Or Flash fill.
Madison Lader
May 05, 2017Copper Contributor
Text to columns did the job. Thank you very much!