Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    concatenate cell + function (XP)

    Say K5 contains a formula =OFFSET(B1,J5,0,1,1)


    I have created a chart. In the title of the chart, I have highlighted it and place =K5 so that it changes. I would like it to say "Value: 1550" where 1550 is the current value in K5. can I concatenate text and a formula in K5?
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: concatenate cell + function (XP)

    You can use the formula
    <code>
    ="Value: "&OFFSET(B1,J5,0,1,1)
    </code>
    in cell K5.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: concatenate cell + function (XP)

    <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22> thank you.........I am rather embarassed now
    Jerry

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: concatenate cell + function (XP)

    Almost weekend... <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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