Consulting

Results 1 to 5 of 5

Thread: Solved: Text and Value in 1 cell is it difficult?

  1. #1

    Solved: Text and Value in 1 cell is it difficult?

    Hello,
    I am wanting to know how you would do thi

    A1 is what your on
    A2 is what you need to be on by the end of the day

    [A1] 50
    [A2] 100
    [A3] Your name


    [B1] Hi [A3] you have completed [A1] of [A2] stats..

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    ="Hi "&A3&" you have completed "&A1&" of "&A2&" stats..."
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Thanks heaps

  4. #4
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    projectaero, please mark your thread solved using the thread tools at the top of the page.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  5. #5

Posting Permissions

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