+ 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,136

    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,136

    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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: text before a formula

    ... or more simply:

    ="Week "&ROW(A1)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

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

    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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: text before a formula

    or type week 1, in the next cell type week 2, select both and drag down or horizontally

+ 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