An odd question about formatting
in [General]
|
Prev: ordeing columns
Next: ranking numbers in a column
From: cvgairport on 18 Jan 2010 11:33 Ok, here's a toughie. I have a list of numbers in column A and I would like in column B a smiliar number of asterisks like this: 4 **** 1 * 9 ********* Any ideas? Amy
From: JR Hester on 18 Jan 2010 11:54 Give the REPT Repeat function a try, I think it will fulfill your needs nicely. "cvgairport" wrote: > Ok, here's a toughie. I have a list of numbers in column A and I would like > in column B a smiliar number of asterisks like this: > > 4 **** > 1 * > 9 ********* > > Any ideas? > > Amy
From: Ron Rosenfeld on 18 Jan 2010 11:55 On Mon, 18 Jan 2010 08:33:01 -0800, cvgairport <cvgairport(a)discussions.microsoft.com> wrote: >Ok, here's a toughie. I have a list of numbers in column A and I would like >in column B a smiliar number of asterisks like this: > >4 **** >1 * >9 ********* > >Any ideas? > >Amy b1: =rept("*",a1) --ron
From: "David Biddulph" groups [at] on 18 Jan 2010 11:55 =REPT("*",A1) -- David Biddulph "cvgairport" <cvgairport(a)discussions.microsoft.com> wrote in message news:A1FFD721-6E37-4A71-84DA-6743EC1B98F8(a)microsoft.com... > Ok, here's a toughie. I have a list of numbers in column A and I would > like > in column B a smiliar number of asterisks like this: > > 4 **** > 1 * > 9 ********* > > Any ideas? > > Amy
From: cvgairport on 18 Jan 2010 12:01
Awesome! Thanks! "JR Hester" wrote: > Give the REPT Repeat function a try, I think it will fulfill your needs nicely. > > "cvgairport" wrote: > > > Ok, here's a toughie. I have a list of numbers in column A and I would like > > in column B a smiliar number of asterisks like this: > > > > 4 **** > > 1 * > > 9 ********* > > > > Any ideas? > > > > Amy |