98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Random Numbers
Random Numbers
Resolved · Low Priority · Version 2003
Thu 12 Mar 2009, 11:24Delegate Anish said...
Anish has attended:
Excel Intermediate course
Excel Advanced course
Random Numbers
How does one create random data (containing numbers and letters) for raw data purposes?
Fri 13 Mar 2009, 08:58Trainer Cress said...
RE: Random Numbers
Hello Anish
Thank you for your question
I usually format a column as text first, then in the first cell I would type AB123 for example and then drag this value down into the cells below. Excel should automatically increment the last number, giving you the random values.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
