Link to home
Start Free TrialLog in
Avatar of maqskywalker
maqskywalker

asked on

incrementing rows containing a string and number by 1 in excel.

I'm using excel 2016

If I have a column like this:

EmployeeID
1
2

If a Select the cell for the number 2 and then I select Fill, then Series and then set Step value 1.
I chose Rows, Linear

When I selected 2 I selected the 3 rows below it and then when I click OK i get this.

That's what want.

EmployeeID
1
2
3
4
5



Now what happens if there i string with a number at the end.

For example i have a column called TestColumn and it looks like this:

TestColumn
testingstring-1
testingstring-2

How do I do the Series so that the number at the end gets incrementing by one?

So my result should look like this:

TestColumn
testingstring-1
testingstring-2
testingstring-3
testingstring-4
testingstring-5
Avatar of Koen
Koen
Flag of Belgium image

if you write it as
teststring 1
teststring 2
it'll work...
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of maqskywalker
maqskywalker

ASKER

perfect