Add a space in data

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

Hi,

Is there a formula that would add a space between two characters?

I have "12:13:09", I would like to add a space before the first colon. (12
:13:09)
 
I had to format the cell as Text and enter 12:13:09 to get this formula to
work.

=LEFT(F1,2)&" "&MID(F1,3,6)

HTH
REgards,
Howard
 
Are these values times?

Or are they text?

If they're text, you could use a formula like:
=SUBSTITUTE(A1,":"," :",1)

If they're times, you could give it a custom format
(format|Cells|number tab|Custom category)
hh :mm:ss

or using a formula and another cell:
=text(a1,"hh :mm:ss")
 
Thank you for your reply. Your sollution does not work for me since my column
was formated to "TIME".

Thank you
 
Way to go, it worked beautifully. It is TIME and the solution was quite
simple.

Thank you
 
Back
Top