Randbetween puzzle??!?

  • Thread starter Thread starter getexel
  • Start date Start date
G

getexel

I want to get an output into an csv file which I am opening in notepad
that reads like:


create (20 )

where 20 is a random number created using randbetween function


At the moment I am getting an output which is:

create (,20 ,)

How can I get rid of those nasty comma's ?:confused: :confused
 
Not knowing how you are creating this, I will take a stab at min
reading.... Is this what you have?

CellA1: Create(
CellB1: RandBetween(0,100) {or some limits}
CellC1: )

If so what you really need is:

="Create(" & RANDBETWEEN(0,100) & ")"

and it should only use one cell.

If I've guessed wrong, post back and I'll take another stab at it.
 
Back
Top