Question

No scam! find the answer.​

Answer 1

a) Colons

To split day, month, year, hours and minutes into separate cells, enter the following characters in the Split by strings box: Dot (.) to separate day, month, and year Colon (:) to separate hours and minutes

Answer 2

$\huge\colorbox{white}{⛦Answer⛦}$

A. column

Columns separates time elements in excel .

The Microsoft Excel SPLIT function will split a string into substrings based on a delimiter. The result is returned as an array of substrings. The SPLIT function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel.