SquirrellyMama Posted February 16, 2011 Share Posted February 16, 2011 Is it possible to combine text and numbers in a formula. So, If I want to schedule TT Lesson 1, TT Lesson2, TT Lesson 3 in excel can I use a formula so I don't have to keep typing TT Lesson #? Kelly Quote Link to comment Share on other sites More sharing options...
Beach Mom Posted February 16, 2011 Share Posted February 16, 2011 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.