pulling data from multiple cells and then adding text

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: pulling data from multiple cells and then adding text

  1. #1
    New Member
    Join Date
    Mar 2004
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default pulling data from multiple cells and then adding text

     
    Hello!

    I'm able to create a field that takes information from two different cells and combines them into the new cell, but I also want to include some standard text in that same cell.

    Specifically, I'm entering heights...as in 5 feet 6 inches. I'd like to be able to enter just a 5 in the first cell, a 6 in the 2nd cell, and have the 3rd cell automatically read 5ft 6in .

    I can get the 5 and 6 to work, but I'm struggling with the integration of the text.

    Can you help?

    TSchordock
    Ohio

  2. #2
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If A1 has feet number and B1 has Inches number then in C1

    =A1 &"ft " & B1 & "in"

  3. #3
    New Member
    Join Date
    Mar 2004
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: pulling data from multiple cells and then adding text

      
    Jacob,

    Thank you! I copied and pasted what you sent me and it worked perfectly.

    Terry

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com