FIND THE ANSWERS

I am trying to merge 2 cells and insert a hyphen between the information in Excel 2010. Is this possible?

Answer this question

  • I am trying to merge 2 cells and insert a hyphen between the information in Excel 2010. Is this possible?


Answers

Answer #1 | 23/12 2013 17:19
Use this formula: =A1&" - "&B1
Positive: 100 %
Answer #2 | 23/12 2013 18:24
Try CONCATENATE(A1, "=", B1)
Positive: 100 %
Answer #3 | 24/12 2013 01:09
You could have given the actual problem in cell references. You cannot use formula for this merge function. How do you expect excel to have the formula to be used as concatenate function. The result only will be shown. YOur problem is not clear. It is confusing so that it does not fetch the first correct answer.
Positive: 100 %
Answer #4 | 23/12 2013 22:42
If the formula remains displayed in the cell after you enter it, instead of returning the result of the formula, it would seem your worksheet is set to Display Formulas. Try pressing the keyboard shortcut Ctrl + ~ (the tilde character is just below the Esc key).
Positive: 100 %
Answer #5 | 25/12 2013 00:12
If the cell is set to Text format, a formula entered into the cell will not calculate. Change the cell to General or another format, press F2 (re-edit cell contents), and press Enter to make the formula calculate. If you want a hyphen inserted "between" two cells, you can add the hyphen (inside double quotes) in the cell's custom format.
Positive: 50 %

Possible answer