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 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" 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  |  Next  |  Last Pages: 1 2 Prev: ordeing columnsNext: ranking numbers in a column