Jump to content


Excel ?

Recommended Posts

Here is one way to do it. This is not a function Excel does gracefully, but this works if your lessons incrementally advance.


Basically you are using Excel to count between your first row and subsequent rows as a means of incrementing.


Your first formula, assuming you are putting it in a column other than B would be

="TT Lesson "&ROWS(B$1:B1)

This should calculate to TT Lesson 1


the next cell would be

="TT Lesson "&ROWS(B$1:B2)

which should be TT Lesson 2


If you copy this formula down the column it should automatically increment your lesson numbers for you.


Hope that helps.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...