combining cells

B

bubba1965

I have a worksheet without about 2,000 rows. I want to take the data i
column b and the data in column d and combine them by seperating with
hyphen and placing in an adjacent column in the same row.

Is this possible. I hope this makes sense.

For example in Row 1 column b, I have the number 75, in Row 1, colum
d I have the number 65, I want the result to be in Row 1, Column e
"75-65". I do not want any mathematical formulas applied, I just wan
the numbers 75-65

Any help would be greatly appreciated
 
F

Frank Kabel

Hi
just click with the left mouse button on the lower right corner (a
small cross should appear). Now drag (while<holding the left mouse
button down) as far as you need
 
S

Suzan

Don't forget to select the new column and do a copy, paste special values. Otherwise, if you delete the other two columns, you'll bet an error message.
 
K

Ken Wright

Either as Frank said, or another option is to select the cell your formula is
in, do Edit / Copy, then select the range you wish to paste it to and do Edit /
Paste. Shortcut keys for that are CTR+C and then CTRL+V. Formulas will adjust
automatically as they get pasted in.
 
B

bubba1965

Thanks for all of your help. I am trying to understand the logic behin
the formula - so I don't have to ask so many questions all of the time


What does the & symbolize, and why is it in behind the cell (B3&) o
the first instance and in front of the cell of the second instanc
(&D3)
 
F

Frank Kabel

Hi
the & does the concatenation With & you can combine two strings
so =A1 & B1 combines the values of A1 and B1 to one string. It's a
shortcut for the CONCATENATION formual.

=A1 & B1 is the same as
=CONCATENATE(A1,B1)
 
Top