Forum Discussion
Changing time only from 24hr to 12hr in a date time cell
Depends on how data is structured, but in general by formulas.
One variant, select column with such texts, Data->Texts to Columns, on second step is Space as delimiter
on third step Date for first column with MDY
Sum received columns in another one, copy result and Paste as values, apply any desired format.
That's okay if in source column in some cells will be texts (e.g. headers), above affects them if only texts have space inside. When also will be split.
Depends on how data is structured, but in general by formulas.
One variant, select column with such texts, Data->Texts to Columns, on second step is Space as delimiter
on third step Date for first column with MDY
Sum received columns in another one, copy result and Paste as values, apply any desired format.
That's okay if in source column in some cells will be texts (e.g. headers), above affects them if only texts have space inside. When also will be split.
- Thanks Sergei. That solved my issues.
Echosteve , you are welcome