combining cells

  • Thread starter Thread starter bubba1965
  • Start date Start date
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
 
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
 
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.
 
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.
 
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)
 
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)
 
Back
Top