Thread: Need help adding :

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.

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.

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.

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.

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.