excel help

[nikhilboorla]

I have 1000 records in format like 20150911184028 and want to convert into 2015-09-11 18:40:28  Any suggestion for how to convert string to timestamp for all fields in excel

[timmy]

is it OK to split the number into two different cells, like date in one cell & time in another cell??

 

if so first split them into two different cells & then follow the steps in the  link below

https://www.extendoffice.com/documents/excel/3467-excel-convert-serial-number-to-date.html

 

 for the external link

 

never tried both time & date in a cell. if you figured it out plz let me know. Thanks

 

 

 

[BUDDY]

1 minute ago, timmy said:

is it OK to split the number into two different cells, like date in one cell & time in another cell??

 

if so first split them into two different cells & then follow the steps in the  link below

https://www.extendoffice.com/documents/excel/3467-excel-convert-serial-number-to-date.html

 

 for the external link

 

 

 

and then u can concatenate both the fields again  

[timmy]

Just now, BUDDY said:

and then u can concatenate both the fields again  

yupp

 

@ TS here's another link how to concatenate

https://www.extendoffice.com/documents/excel/1538-excel-combine-date-and-time.html

[nikhilboorla]

thanks,i will try

[nikhilboorla]

i am finding how to split number  20150911184028  to  date 20150911 and  time 184028 

[timmy]

Just now, nikhilboorla said:

i am finding how to split number  20150911184028  to  date 20150911 and  time 184028 

 

https://www.extendoffice.com/documents/excel/1669-excel-separate-area-code-from-phone-number.html

 

[nikhilboorla]

i am able to make  20150911  as 2015-09-11 but unable to make  184028  in time format(i have tried Format cells option in excel)

[timmy]

12 minutes ago, nikhilboorla said:

i am able to make  20150911  as 2015-09-11 but unable to make  184028  in time format(i have tried Format cells option in excel)

Hmm!! aa time column ni copy chesi new column lo paste special lo paste as values & numbers ani  cheyyi dhen try again for new column.  (edited)

[rrc_2015]

I would use notepad++ to insert a space in all the records in one go. 

Copy 1000 Records into n++ . Move cursor to the position where you wanna to insert space (or any character) . Now use alt + shift + down arrow to the end . Now type what ever you want. It will insert into 1000 rows in one go.

[chicchara]

lets imagine your date is in Cell A2

use the below formula for it

=CONCATENATE(MID(A2,1,4),"-",MID(A2,5,2),"-",MID(A2,7,2)," ",MID(A2,9,2),":",MID(A2,11,2),":",MID(A2,13,2))

[spider_reddy]

1 hour ago, rrc_2015 said:

I would use notepad++ to insert a space in all the records in one go. 

Copy 1000 Records into n++ . Move cursor to the position where you wanna to insert space (or any character) . Now use alt + shift + down arrow to the end . Now type what ever you want. It will insert into 1000 rows in one go.

same pinch nenu ide vadatha....avaro oka mahanu bavudu naku idi nerpichadu first job lo ....adi leka pothe pani vasi poyedi

[Picha lite]

Contact ABO  

[rrc_2015]

29 minutes ago, Picha lite said:

Contact ABO  

ABO only do calculations. Concat kastam. 

If cherry movie , collections*2

If cunny, collections*3