Great site... Quick question..

G

Guest

Guest
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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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).
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
Thanks all,
Looks like anyone of these would work.

Ru
This message was edited by Ruious on 2002-02-20 08:52
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,089
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top