+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    02-26-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Pulling the value from a cell into a text cell

    Hey all,

    I've been searching around and I know what I want to do but I don't know what it's called in Excel. This is an example of what I want to do:

    A1: "I am B2 years old"
    B2: "22"

    So it would show up as:

    I am 22 years old

    Any help at all would be greatly appreciated.


    Nitz

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    MSO2007 on WinXP/MSO2000 on Win7
    Posts
    1,958

    Re: Pulling the value from a cell into a text cell

    In A1:
    Code:
    ="I am " & B1 & " years old"
    ---
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-26-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pulling the value from a cell into a text cell

    I think I love you. Thank you so much! Now I have to use it like 50 million times but it's great knowing that I can.

    Thank you!

Thread Information

Users Browsing this Thread

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

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.2.0