Great site... Quick question..

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

[NateO]

Howdy Anon,

try:

=a1&b1

Cheers,

Nate

[bomalley]

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

[Aladin Akyurek]

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

[Jack in the UK]

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

[NateO]

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 ]

[RichardS]

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

[NateO]

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 ]

[Ruious]

Thanks all,
Looks like anyone of these would work.

Ru

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