B
Bob Arnett
I'm trying to use the same random number twice in the same cell formula:
I entered "=TEXT(RANDBETWEEN(1,255),"000 ")&CHAR(RANDBETWEEN(1,255))"
to display both an ASCII number and its character but this generates a
different random number for each "randbetween" instead of the same one. I
could use a helper column but I just wonder if this would somehow be possible
within the same cell.
I entered "=TEXT(RANDBETWEEN(1,255),"000 ")&CHAR(RANDBETWEEN(1,255))"
to display both an ASCII number and its character but this generates a
different random number for each "randbetween" instead of the same one. I
could use a helper column but I just wonder if this would somehow be possible
within the same cell.