Repeating Characters in Cells with info.

  • Thread starter Stressed Student
  • Start date
S

Stressed Student

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?
 
D

Dave Peterson

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.
 
S

Stressed Student

This is exactly what I want to do, but I am not quite understanding how I can
do that.
 
Top