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 wou...
Hello Madison
Use Text-to-columns.
Or Flash fill.
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.