Formula to fill a cell

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

What is the new formula in Office 2003 to fill a cell with
a symbol. I used to use /- which was from lotus. That
will not work now and the repeat function will only give
you the option on a specific number.
 
Nikki,

Use

=REPT("-",1000)

and put a space in the cell to the right, which will truncate the long line
of -s at the end of the cell with the formula.

HTH,
Bernie
MS Excel MVP
 
<Format> <Cells> <Alignment> tab,

And expand the "Horizontal" box and click on "Fill", then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


What is the new formula in Office 2003 to fill a cell with
a symbol. I used to use /- which was from lotus. That
will not work now and the repeat function will only give
you the option on a specific number.
 
Here's something else that you may like
try putting - in the cell to get-------------
try putting space - in the cell to get - - - - - -
 
Thanks that worked great!
-----Original Message-----
Here's something else that you may like
try putting - in the cell to get-------------
try putting space - in the cell to get - - - - - -

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
Back
Top