| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pick up data from left of a space starting from the right? | Excel Discussion (Misc queries) | |||
| Discovering No-BREAK Space in cell Data | Excel Discussion (Misc queries) | |||
| Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
| How do I shade the space between two data series in Excel? | Charts and Charting in Excel | |||
| space between y axis and data points.. | Charts and Charting in Excel | |||
Linear Mode
