If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add a space in data
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Add a space in data
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 "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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Add a space in data
Thank you for your reply. Your sollution does not work for me since my column
was formated to "TIME". Thank you -- smile "L. Howard Kittle" wrote: 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 "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 |
#6
|
|||
|
|||
Add a space in data
Way to go, it worked beautifully. It is TIME and the solution was quite
simple. Thank you -- smile "Dave Peterson" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|