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?

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

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

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