=VALUE(CONCATENATE(A2,"/",B2,"/",C2," ",D2,":",E2,":", F2))
The Worth perform convert the textual content into numbers.
The Concatenate perform connects all of the textual content and convert them into one string.
Tuesday, March 24, 2015
Concatenate text and convert to numbers in Excel
I've an extended Excel file which hold the date, month, yr, hour, minute, and second in separate columns (determine 1). I need to use just one column to current the time, so it will be simpler to plot the time as x-axis. Right here is the perform I utilized in cell G2:
=VALUE(CONCATENATE(A2,"/",B2,"/",C2," ",D2,":",E2,":", F2))
The Worth perform convert the textual content into numbers.
The Concatenate perform connects all of the textual content and convert them into one string.
=VALUE(CONCATENATE(A2,"/",B2,"/",C2," ",D2,":",E2,":", F2))
The Worth perform convert the textual content into numbers.
The Concatenate perform connects all of the textual content and convert them into one string.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment