View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Fill Cell with Asterix

If I remember correctly, it wasn't a key it was a formula. In Lotus 1-2-3 it
was the REPEAT function in Excel it's the REPT function

=REPT(TextToRepeat,NumberOfRepetitions)

=REPT("*",300)
--
Kevin Backmann


"Paul Black" wrote:

Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul