Forum home » Delegate support and help forum » Microsoft Excel Training and help » Random Numbers

Random Numbers

ResolvedVersion 2003

Thu 12 Mar 2009, 11:24 Delegate 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:58 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Random Numbers

Random Numbers

RE: Random Numbers

Excel articles

Excel tip:

Screen Splitters in Excel