Need help adding :
 

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.

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?

--
Regards,

Dave


"Mark" wrote:

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.

Yes they are 4 digit. Thank you VERY much.

"DaveB" wrote:

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?

--
Regards,

Dave


"Mark" wrote:

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.