View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Add a space in data

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")

israel wrote:

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)
--
smile


--

Dave Peterson