| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeating Characters in Cells with info.
I am trying to repeat a period to connect every column in a list of marathon
records. I want it to read name.............time..............date........... ....location. how do i write the formula to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeating Characters in Cells with info.
You could give the cells a custom format of:
General*.;-General*.;0*.;@*. Positive;negative;0;text The *. says to repeat the dot enough to fill the cell (to the right). You may not want it on the numbers, though. Stressed Student wrote: I am trying to repeat a period to connect every column in a list of marathon records. I want it to read name.............time..............date........... ....location. how do i write the formula to do this? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeating Characters in Cells with info.
This is exactly what I want to do, but I am not quite understanding how I can
do that. "Dave Peterson" wrote: You could give the cells a custom format of: General*.;-General*.;0*.;@*. Positive;negative;0;text The *. says to repeat the dot enough to fill the cell (to the right). You may not want it on the numbers, though. Stressed Student wrote: I am trying to repeat a period to connect every column in a list of marathon records. I want it to read name.............time..............date........... ....location. how do i write the formula to do this? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeating Characters in Cells with info.
Follow ups in first thread.
Stressed Student wrote: This is exactly what I want to do, but I am not quite understanding how I can do that. "Dave Peterson" wrote: You could give the cells a custom format of: General*.;-General*.;0*.;@*. Positive;negative;0;text The *. says to repeat the dot enough to fill the cell (to the right). You may not want it on the numbers, though. Stressed Student wrote: I am trying to repeat a period to connect every column in a list of marathon records. I want it to read name.............time..............date........... ....location. how do i write the formula to do this? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add the same character(s) to multiple cells in a column (or row) . | Excel Discussion (Misc queries) | |||
| find cells that contain specific characters | Excel Worksheet Functions | |||
| help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
| Prefill cust info from drop list into other cells | Excel Worksheet Functions | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Linear Mode
