Filling a colun with a series of numbers
Closed
Marilyn
-
23 Jul 2009 à 09:38
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 23 Jul 2009 à 22:52
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 23 Jul 2009 à 22:52
Related:
- Filling a colun with a series of numbers
- Comedy series prime video - Guide
- How to zoom out on xbox series x - Guide
- Xbox series x 3d blu ray - Guide
- Apple watch series 8 specs - Guide
- Superhero series - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
23 Jul 2009 à 22:52
23 Jul 2009 à 22:52
Hello Marilyn
In one column in rows 2 onwards enter a,b,c etc
in first row of column B onwards enter 1,2,3 ...
In cells B2 enter the formula =B$1 & $A2 and drag
Copy the entire data and then paste special as values
In one column in rows 2 onwards enter a,b,c etc
in first row of column B onwards enter 1,2,3 ...
In cells B2 enter the formula =B$1 & $A2 and drag
Copy the entire data and then paste special as values