Repeating Characters in Cells with info.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
This is exactly what I want to do, but I am not quite understanding how I can
do that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can i get an table to look like a formatted table 9
Repeat formula 4
find -> list of records 2
How to use pivot table to count repeats of unique fields 4
repeating cells 2
How do I repeat characters within a single cell in Excel? 3
Remove Sequential Repeats 2
Help with Array formula? 4

Back
Top