Thanks:  0
Likes:  0

# Thread: Great site... Quick question..

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

ru

2. Howdy Anon,

try:

=a1&b1

Cheers,

Nate

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

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

#### Posting Permissions

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