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.
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, India
Do let me know if this is required.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
Yah, Excel is infinite... Any result could be achieved by few different ways.