View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default Add a space in data

Format it as
h" ":mm:ss

"israel" wrote in message
...
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