Need help adding :

M

Mark

I need some help, desperately. I was sent a spreadsheet with several
thousand entries, and all of the dates reported as (example) 1015. Is there
a function that I can go into the next column and say " take value in A1 and
move over two places, add a ":", in theory converting them to a proper format
for time. Any help would be greatly appreciated.
 
D

DaveB

Assume your values start in A1, put this formula in B1:

=CONCATENATE(LEFT(A1,2),":",RIGHT(A1,2))

Note: This assumes every entry is 4 digits long though, is this the case for
all the entries?
 
M

Mark

Yes they are 4 digit. Thank you VERY much.

DaveB said:
Assume your values start in A1, put this formula in B1:

=CONCATENATE(LEFT(A1,2),":",RIGHT(A1,2))

Note: This assumes every entry is 4 digits long though, is this the case for
all the entries?
Click to expand...
 
Top