+ Reply to Thread
Results 1 to 7 of 7

text before a formula

  1. #1
    Registered User
    Join Date
    09-07-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    12

    text before a formula

    I'm trying to make a school register. on one sheet there will be 52 weeks worth of attendance.
    at the top of each week i want to write WEEK 1, WEEK 2, WEEK 3 ETC.

    instead of having to type Week 2, Week 3.... (i.e. having to change the number 52 times.. can i do a formula like:

    ="Week" +1

    so that the next cell will be "1 more" than its previous one, along with the word WEEK appearing each time?

    thanks

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: text before a formula

    Try the following:

    Type "Week1" in the first cell, then the below formula in next cell.

    ="Week"&MID(A1,5,2)+1

  3. #3
    Registered User
    Join Date
    09-07-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    12

    Re: text before a formula

    thanks a million. works brilliantly!

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: text before a formula

    You are welcome

    If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,988

    Re: text before a formula

    ... or more simply:

    ="Week "&ROW(A1)
    Glenn



  6. #6
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: text before a formula

    Quote Originally Posted by Glenn Kennedy View Post
    ... or more simply:

    ="Week "&ROW(A1)
    OR
    ="Week "&COLUMN(A1) , if the formula has to be dragged horizontally.

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: text before a formula

    or type week 1, in the next cell type week 2, select both and drag down or horizontally
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-04-2014, 01:47 PM
  2. [SOLVED] Find & Replace Formula for Locating Short Text within Larger Text
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2014, 05:04 PM
  3. [SOLVED] Find & Replace Formula for Locating Short Text within Larger Text
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2014, 08:47 PM
  4. Formula to find and return text string within a cell full of text strings
    By LightingPop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 11:45 PM
  5. [SOLVED] Extract text from a string of text (amend formula to include new criteria)
    By robertguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2013, 04:53 PM
  6. Replies: 6
    Last Post: 06-08-2012, 06:54 PM
  7. Replies: 0
    Last Post: 06-03-2010, 01:11 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1