Great site... Quick question..
Great site... Quick question..
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Great site... Quick question..

  1. #1
    Guest

    Default

     
    thank god for you all, of course after seeing the combined brain power in this forum, I just might bring down the average..LOL

    Question I want to combine two cells and keep the data intact when finished..
    ie..Cell A1 408 Cell B1 866, Cell C1 408866

    Thanks in advance.
    ru

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Howdy Anon,

    try:

    =a1&b1

    Cheers,

    Nate

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there,

    Just enter this formula in C1
    =RIGHT(A1,3)&RIGHT(B1,3)

    What it does is returns the first three characters from the right of Cell A1 and B1, and combines them. If nyou want it to return more characters, increase the number after the cell reference (e.g. 3 becomes 4).

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,803
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-02-19 17:08, NateO wrote:
    Howdy Anon,

    try:

    =a1&b1

    Cheers,

    Nate
    =(A1&B1)+0

    if you want the concatenation result to be a number.

    Aladin

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    I tend to expand a littel an encourage people to do the same L

    Try =A1 & "" & B1
    Guives the same result but some times you need to split dat so change to " " and that gives the split, this is standard for me any might help soon. Just my way..

    Rdgs
    ==========
    Jack

  6. #6
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Al,

    When I try this:

    =a1&b1

    I actually get a number (although it is left-justified). Just to throw it out there....

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-02-19 17:17 ]

  7. #7
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You don't, actually. If you add 1 to the result, you will get a number, because you are performing a mathematical function on it, which is what Aladin's formula does. If however you sum the three cells, you will only get the sum of the first two, so the a1&b1 does not actually produce a number
    Richard

  8. #8
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I see what you're saying. If I do =sum(a1:c1) I only get the sum of a1 & b1. But, if I add +a1+b1+c1 it works (whereas Al's works either way)!

    How odd. Nice catch.

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-02-19 20:31 ]

  9. #9
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks all,
    Looks like anyone of these would work.

    Ru

    [ This Message was edited by: Ruious on 2002-02-20 08:52 ]

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