Replacing invisible character so that TimeStamp works

[finnexcel]

I have timestamps that equal: 30/03/2012*23:54:00

I am trying to make them into time serials.

If I manually edit cell - backspace then press spacebar - they convert fine

Tried using =replace(a1,11,1," ")

But it didnt work.

Any ideas how to get it to convert the bad timestamps to a usable one using a formula?

 

[VoG]

Continuation of http://www.mrexcel.com/forum/showthread.php?t=625477

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).