Change cell format/value based on the value of another cell (time format transformation)

Hello guys,

I'm new on this forum and I need some expert help.

I have a spreadsheet with values on A_column and I need those changed to a different format.

For example:

A_column = B_column

30.08(14:23) = 300820171423
01.09(07:22) = 010920170722
05.09(07:50) = 050920170750
07.09(07:19) = 070920170719
08.09(12:13) = 080920171213
10.09(13:17) = 100920171317
11.09(08:36) = 110920170836
12.09(12:49) = 120920171249
13.09(08:30) = 130920170830
14.09(15:31) =
18.09(16:00) =
19.09(08:00) =
20.09(09:07) =
21.09(12:43) =

I need a formula to change A values to B values.

Basically, those are dates:
A = dd.mm(hh:mm) (A column format is set to General)
B = ddmmyyyyhhmm

Does anyone have a clue for my problem?

Thank you,
Leo

May be
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(","2017"),".",""),":",""),")","")

Originally Posted by gondal

May be
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(","2017"),".",""),":",""),")","")

This one works. Thank you so much!!

Originally Posted by etaf

column A
are the first 5 characters always just 5 characters and always 2 char decimal 2 char and will it always be 2017 - or how is the year known

=left(a1,5)*100
the add the year

=left(a1,5)*100&"2017"
then ADD
=MID(A1,7,2)&MID(A1,10,2)


=left(a1,5)*100&"2017"&MID(A1,7,2)&MID(A1,10,2)

Doesn't work, but thank you