Generating random letters in Numbers
Is there a way to generate a random letter of the alphabet to a cell?
I set up letters A-Z in a column but I can't reference it from a random number.
[Re-Titled by Moderator]
You could use this formula directly:
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
8 replies
There are no custom functions or formulas in Numbers.
drrichard wrote:
Is there a way to stop the updating, maybe by permanently turning the letter that's generated into a regular character?
Select the cell(s) with the formula, command-c to copy, Edit > Paste Formula results. That removes the formula.
SG
Thank you!!!
Is there a way to save a custom function or formula? I have not found such a menu item.
Just bear in mind that RANDBETWEEN() will update (and generate a new value) any time any cell on the sheet is edited. That may be OK.. just something to be aware of.
Is there a way to stop the updating, maybe by permanently turning the letter that's generated into a regular character?
Thank you for the help.
Generating random letters in Numbers